if exists(select * from TableName where Conditons) begin insert TableName ...... end else return 0
create proc insert_ ( @userName varchar(10), ... ) as declare @uID bigint select @uID=ID from login where userName=@userName if (@uID is null) begin INSERT INTO login(userName...) VALUES(@userName.... ) end
可以用存储过程去写个小脚本检查存在否,也可以用事务方式来处理 Begin Tran --SQL 语句 if @error <> 0 Tran Commit else Tran Rollback
begin
insert TableName ......
end
else
return 0
(
@userName varchar(10),
...
)
as
declare @uID bigint
select @uID=ID from login where userName=@userName
if (@uID is null)
begin
INSERT INTO login(userName...)
VALUES(@userName.... )
end
Begin Tran
--SQL 语句
if @error <> 0
Tran Commit
else
Tran Rollback
Tran Commit
好像少了一个@吧