一:更新/新增一条语句,返回其中某一列的值
update product set state=1
output inserted.state
where id=@id
二:新增一条语句,返回自增列Id
insert into Product values();select @@IDENTITY() as new_id
一:更新/新增一条语句,返回其中某一列的值
update product set state=1
output inserted.state
where id=@id
二:新增一条语句,返回自增列Id
insert into Product values();select @@IDENTITY() as new_id