这个存储过程怎么写?

我想在用户表里创建一个新用户,如果给出参数用户名已经存在返回
一个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

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus