select @LoginFlag=isnulll(ID字段,0) FROM Users WHERE UserName=@UserName and UserPassword=@UserPassword return @LoginFlag
create proc p @UserName nvarchar(20), @UserPassword nvarchar(20) as delcare @LoginFlag int select @LoginFlag=isnulll(ID字段,0) FROM Users WHERE UserName=@UserName and UserPassword=@UserPassword return @LoginFlag go
return @LoginFlag
@UserName nvarchar(20),
@UserPassword nvarchar(20)
as
delcare @LoginFlag int
select @LoginFlag=isnulll(ID字段,0) FROM Users WHERE UserName=@UserName and UserPassword=@UserPassword
return @LoginFlag
go