SQL Server Output

CREATE TABLE T3

(

SID int NOT NULL primary key,

Sname varchar (10)

)

INSERT into T3 values ("Wind")

INSERT into T3 values (102, ' snow ')

INSERT into T3 values (the ' 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

--Returns the value before and after the update field

update T4 set sname= ' Snow '

Output Deleted.sname,inserted.sname

where sid=101

----Delete

--Returns the deleted value

Delete T4

Output Deleted.sid,deleted.sname

where sid=103

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/SQLServer/