RE: [DUG-DB]: Getting unique ID through SQL

[vss]

Just a By-the-By....if no one knew this, there is a very cool function in SQL Server 7 
called NEWID

-- Creating a local variable with DECLARE/SET syntax.

DECLARE @myid uniqueidentifier

SET @myid = NEWID()

PRINT 'Value of @myid is: '+ CONVERT(varchar(255), @myid)

this really does work. we use it now more and more, and is more reliable that a table 
that stores the last number, and adding one to it !


Cheers Jeremy Coulter
 
 
 

---------------------------------------------------------------------------
  New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz