zcs_adduser.sql

来自「RSS新闻订阅浏览系统」· SQL 代码 · 共 20 行

create procedure zcs_addUser
(
	@userId varchar(50),
	@userName varchar(50),
	@password varchar(50),
	@returnMessage varchar(50) output
)
as
	declare @isinuse integer
	select @isinuse = count(userId) from users where userID=@userId
	if @isinuse = 0
		begin
			insert into users(userID,userName,password) values (@userId,@userName,@password)
			set @returnMessage=''
		end
	else
		begin
			set @returnMessage='添加的用户已经存在!'
		end
GO