Thursday, 5 September 2013

Implement if else statement in MS SQL Stored Procedure

Implement if else statement in MS SQL Stored Procedure

Using sql server 2008 r2
begin
insert tablename1(param1, param2)values(@param1,@param2)
if(@param1=="2222" && @param2<5)
set @param2 =@param2+1
update tablename2 set param2=@param2 where param1=@param1
end
end
How to implement sql procedure like this

No comments:

Post a Comment