ASP.NET with C# and SQL SERVER , some vb.net . asp.net examples, asp.net codes, asp.net programs, c# code, sql server queries, important codes.
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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment