sqlserver output

概述  create table t3 ( sid int not null primary key, sname varchar(10) ) insert into t3 values(101,'wind') insert into t3 values(102,'snow') insert into t3 values(103,'kiki') select * from t3 select * in

 

create table t3
(
sID int not null primary key,
sname varchar(10)
)

insert into t3 values(101,'wind')
insert into t3 values(102,'sNow')
insert into t3 values(103,'kiki')

select * from t3

select * into t4 from t3 where 1=0

select * from t4

----insert

insert into t4
output inserted.sID,inserted.sname
select sID,sname from t3

---update
--返回update字段前后的值
update t4 set sname='sNow'
output deleted.sname,inserted.sname
where sID=101

----delete --返回删除的值 delete t4 output deleted.sID,deleted.sname  where sID=103

总结

以上是内存溢出为你收集整理的sqlserver output全部内容，希望文章能够帮你解决sqlserver output所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。