select @cust_id = cust_id from x where cust_name=@name