返回上一句SQL语句生成的GUID
INSERT INTO T_PGM_ViewRole(ID) SELECT NEWID()
我下面的一条SQL语句要用到这个新产生的GUID 我如何得到这个GUID啊?
[解决办法]
decare @t table (guid guid)INSERT INTO T_PGM_ViewRole(ID)output into @t(guid) SELECT NEWID()--从表@t里获取
[解决办法]
decare @t table (guid guid)INSERT INTO T_PGM_ViewRole(ID)output inserted.ID into @t SELECT NEWID()--从表@t里获取
[解决办法]
没闹啊。。
[解决办法]
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
[解决办法]