go

--插入并返回每行的插入值

DECLARE @NewRows TABLE(Id INT ,NAME NVARCHAR(),Sorce INT )

INSERT INTO dbo.Student

OUTPUT INSERTED.id,INSERTED.Name,INSERTED.Sorce INTO @NewRows

SELECT Name, Course, Sorce FROM Student WHERE Sorce<

SELECT * FROM @NewRows

go

--删除返回删除的结果

DECLARE @DelRows TABLE(Id INT,NAME NVARCHAR())

DELETE dbo.Student

OUTPUT DELETED.Id,DELETED.Name INTO @DelRows

WHERE Name='新更改'

SELECT * FROM @DelRows

go

--更新数据返回更新行、新老数据

DECLARE @UpdateRows TABLE(Id INT,OldSorce INT ,NewSource INT)

UPDATE dbo.Student SET Sorce=Sorce+

OUTPUT INSERTED.Id,DELETED.Sorce,INSERTED.Sorce INTO @UpdateRows

WHERE Name='王五'

SELECT * FROM @UpdateRows