Sunday, 2 December 2012

stored procedure in sql server


set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[inseruser]
(
@username varchar(50),
@password varchar(50),
@firstname varchar(50),
@lastname varchar(50),
@city varchar(50)
)
AS
Begin
declare @usercount int
declare @ReturnValue int

select @usercount=count(*) from users where username=@username

if @usercount=0
begin
insert into users (username,password,firstname,lastname,city)
values(@username,@password,@firstname,@lastname,@city)
set @ReturnValue=1
end
else
begin
set @ReturnValue=2
end
return @ReturnValue
End

No comments:

Post a Comment