zcs_login.sql

RSS新闻订阅浏览系统

create procedure zcs_login
(
	@userId varchar(50),
	@password varchar(50),
	@returnMessage varchar(50) output
)
as
	declare @row integer
	select @row = count(*) from users where userID=@userId and password=@password
	print @row
	if @row=0
		begin
			set @returnMessage='登录失败!'
		end
	else
		begin
			set @returnMessage='登录成功!'
		end
	print @returnMessage
go