| Author: venu kumar 05 Sep 2008 | Member Level: Silver | Rating:  Points: 1 |
http://aspnet101.com/aspnet101/tutorials.aspx?id=39
|
| Author: ANIL PANDEY 05 Sep 2008 | Member Level: Diamond | Rating: Points: 6 |
hi,
u can refer the Stored Procedures for the Sql thats is like..
Create PROCEDURE [dbo].[SaveUpdateUser]
(@ID int,@UName VarChar(100),@Pwd VarChar(50),@UType int,@UStatus int, @Mode int,@Result int output)
AS
BEGIN
if(@Mode=1) --Save
begin
INSERT INTO tbUsers
(UserName,Pwd,Ac_Status,UserStatus,USerType)
values
(@UName,@Pwd,'E',@UStatus,@UType)
end
else if (@Mode=2) --Edit
begin
UPDATE tbUsers SET
UserName=@UName,Pwd=@PWD,USerType=@UType,UserStatus=@UStatus WHERE Sno=@ID
end
if (@@error<>0)
begin
set @Result =-1 --Error Occured
return @Result
end
else
--checking if Mode=1(Save) then return Identity else(Edit) return 1(Which represent successfull execution as compare to negative value)
if(@Mode=1)
begin
set @Result =@@IDENTITY ----Successfuly Executed
return @Result
end
else
begin
set @Result =1 ----Successfuly Executed
return @Result
end
END
Thanks
Anil
|