--要插入数据的表，包含一个uniqueidentifier字段
create table tb(nid uniqueidentifier default(newid()), name varchar(32))

--定义一个存储uniqueidentifier的表
declare @tb table(nid uniqueidentifier)

--插入数据，并将uniqueidentifier字段内容存入@tb
insert tb(name) 
output inserted.nid into @tb(nid)
values('dobear')

--从@tb中猎取uniqueidentifier字段的值
declare @nid uniqueidentifier
select @nid=nid from @tb

select @nid
/*
203A98E7-2CE6-4893-888C-61AB6150D438
*/

drop table tb

如:
create table t(ID uniqueidentifier)
--程序
create proc P(@ID uniqueidentifier)
as
insert T values(@ID)
go
create proc P(@ID uniqueidentifier output)
as
set @ID=newID()
insert T values(@ID)

CREATE TABLE Test
(
PKID INT IDENTITY(1,1) PRIMARY KEY ,
Column1 VARCHAR(50),
GUID UNIQUEIDENTIFIER DEFAULT NEWID()
)

INSERT INTO Test (Column1) VALUES ('abc')
select @@IDENTITY

SELECT GUID FROM Test Where PKID=@@IDENTITY

SELECT TOP 1 GUID FROM Test ORDER BY 1 DESC