返回上一句SQL语句生成的GUID解决思路_Sql Server

返回上一句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()[email protected]
------解决方案--------------------
SQL codedecare @t table (guid guid)INSERT INTO T_PGM_ViewRole(ID)output inserted.ID into @t SELECT NEWID()[email protected]
------解决方案--------------------
没闹啊。。
------解决方案--------------------
SQL codecreate 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……