T-SQL Syntax

[lakshmi_sri]

how can i save the value of a field into a parameter in T-SQL?what i wrote is- Create Procedure a_c @C_Name varchar(100), as if exists( select id as 'ID' from ABC where C_Name = @C_Name) begin ---- end else begin --- end go is this syntax correct?and should i declare 'ID'and how can i do it?

[zhengdong jin]

-- create proc create proc abc @para int output as set @para = 1 go --exec proc declare @p int exec abc @p output select @p