原文地址:http://blogs.microsoft.co.il/gilf/2010/05/09/how-to-retrieve-stored-procedure-output-parameters-in-entity-framework/ How to Retrieve Stored Procedure Output Parameters in Entity Framework One question that raises from time to time in EF forums
最近项目中使用了SCOPE_IDENTITY()来获取新增数据的自动递增ID号. 在运行过程中会不时的发生无法通过SCOPE_IDENTITY()来获取ID号的情况. 尝试着测试又发现不了问题. 今天在官网发现了OUTPUT可以代替使用. 先尝试一个例子: Create Table dbo.test( nid int Identity(1,1), n varchar(20) ) declare @tmptest Table ( nid int, n varchar(20) ) ---新增 ins
sql server2005以后引入: 执行的sql语句中加入output可以事实输出处理的内容 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
原文 A Beginner’s Guide to the OUTPUT Clause in SQL Server T-SQL supports the OUTPUT clause after the inception of SQL server 2005 and later editions. We can use the OUTPUT clause with DML statements (INSERT, DELETE, UPDATE) to return information from