我想在用户表里创建一个新用户,如果给出参数用户名已经存在返回
一个false值,否则insert一个新用户!请问该怎么写?谢谢!
---------------------------------------------------------------
if not exists (select * from usertable where username = @name)
insert into usertable (name) values (@name)
---------------------------------------------------------------
CREATE PROCEDURE up_adduser (@name varchar(10),@rtn bit output)
AS
if not exists (select * from usertable where username = @name)
insert into usertable (name) values (@name)
else
return 0