CREATE PROCEDURE [sp_UserVerification]
(
@Username varchar(50),
@Password varchar(50)
) AS
SET NOCOUNT ON
SELECT * FROM Signon WHERE Username = @Username AND Password = @Password
if @@ROWCOUNT >0
update signon set hits = hits + 1 WHERE Username = @Username AND Password = @Password
SET NOCOUNT OFFGO
(
@Username varchar(50),
@Password varchar(50)
) AS
SET NOCOUNT ON
SELECT * FROM Signon WHERE Username = @Username AND Password = @Password
if @@ROWCOUNT >0
update signon set hits = hits + 1 WHERE Username = @Username AND Password = @Password
SET NOCOUNT OFFGO
begin
set hits = hits + 1
end
(
@Username varchar(50),
@Password varchar(50)
) AS
SELECT * FROM Signon WHERE Username = @Username AND Password = @Password
if (@@rowcount=0)
return(-1)
else
update Signon set hits=hits+1 Where Username=@Username
GO
(
@Username varchar(50),
@Password varchar(50)
) AS--加一
SELECT IDENTITY(int, 1,1) AS ID_Num,* into #temp FROM Signon WHERE Username = @Username AND Password = @Password
--实现分页
select * from #temp where ID_Num between 10 and 20
GO