GUID in MS SQL

avalon · #1 (**permalink**) Nov 23rd, 2005, 13:23

Could anyone tell me what the easiest way is to have an automatically generated GUID field in SQL Server? For my purposes the field must be of Text type and just have a default value of a new GUID.

Thanks in advance,
Tim
Web Design

Smokie · #2 (**permalink**) Nov 24th, 2005, 12:25

Code: Select all

DECLARE @GUID uniqueidentifier
SET @GUID = NEWID()
INSERT Item VALUES (@GUID,'text text text')

		Webforumz.com > Main Forums > Program Your Website > Databases
GUID in MS SQL