请帮助我在我的SQL查询 [英] Please help me in my sql query

问题描述

您好，先生，
请帮我查询，告诉我意思

Hello Sir,
Please help me in my query kindly tell me the meaning

INSERT INTO Videos
OUTPUT inserted.*
VALUES(N'War of the Roses (The)', N'Dany de Vito', 0, N'R', 2001),
      (N'Memoirs of a Geisha', N'Rob Marshall', 1, N'PG-13', 2006),
      (N'Last Castle (The)', N'Rod Lurie', 1, N'', 2001),
      (N'Sneakers', N'Phil Alden Robinson', 1, N'PG-13', 2003);

OUTPUT inserted.*是什么意思?

在Advance中致谢

What is the meaning of OUTPUT inserted.* ?

Thanks in Advance

推荐答案

阅读此页面，它对其进行了详细说明:

http://msdn.microsoft.com/en-us/library/ms177564.aspx [ ^ ]

OUTPUT将通过最后一条命令返回受影响的行，这是这里的插入命令.

这是另一个示例:
http://www.kodyaz.com/articles/insert-into-two-tables-using-t-sql-output-clause.aspx [

Read this page, it described it in details :

http://msdn.microsoft.com/en-us/library/ms177564.aspx[^]

OUTPUT will return affected rows by the last command which is an insert command here.

Here is another example :
http://www.kodyaz.com/articles/insert-into-two-tables-using-t-sql-output-clause.aspx[^]


Hope it helps.

这篇关于请帮助我在我的SQL查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！