如果存在又如何?不录入吗?可以 if not exists(select name from table where ltrim(name)=@name ) insert into table (name,pwd) values (@name,@pwd)
是要 判断 不允许 插入 重复 name 的数据?好像没这个吧 ,在程序里面判断下了。
if not exists(select name from table where ltrim(name)=@name ) insert into table (name,pwd) values (@name,@pwd)select name from table where name=@name IF @@ROWCOUNT<>0 insert into table (name,pwd) values (@name,@pwd)
if not exists(select name from table where ltrim(name)=@name )
insert into table (name,pwd) values (@name,@pwd)
if not exists(select name from table where ltrim(name)=@name )
insert into table (name,pwd) values (@name,@pwd)select name from table where name=@name
IF @@ROWCOUNT<>0
insert into table (name,pwd) values (@name,@pwd)