create procedure ex (@name varchar(200))
as
declare @cust_id int
where cust_name=@name
if(@cust_id='')
begin
insert into x(cust_name) values(@name)
end
GO