返回上一句SQL语句生成的GUID
INSERT INTO T_PGM_ViewRole(ID) SELECT NEWID()
我下面的一条SQL语句要用到这个新产生的GUID 我如何得到这个GUID啊？


[解决办法]

SQL code

decare @t table (guid guid)INSERT INTO T_PGM_ViewRole(ID)output into @t(guid) SELECT NEWID()--从表@t里获取
[解决办法]
SQL code
decare @t table (guid guid)INSERT INTO T_PGM_ViewRole(ID)output inserted.ID into @t SELECT NEWID()--从表@t里获取
[解决办法]
没闹啊。。
[解决办法]
SQL code
create proc pr_name(@id nvarchar(30) out)asbegin    set @id=NEWID()    INSERT INTO T_PGM_ViewRole(ID) SELECT @idenddeclare @id nvarchar(30) exec pr_name @id outputprint @id
[解决办法]
探讨

SQL code
create proc pr_name(@id nvarchar(30) out)
as
begin
    set @id=NEWID()
    INSERT INTO T_PGM_ViewRole(ID) SELECT @id
end

declare @id nvarchar(30) 
exec pr_name @id output
print @id……