Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unique String Function
Message
 
 
To
20/02/2004 07:19:07
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00879123
Message ID:
00879141
Views:
16
>Can anyone tell me if MSSQL Server has a built in function to generate a unique character string? VFP, for example has the SYS(2015) function which generates a unique 10 character string based on the date and time. I want to create an insert trigger that will assign this unique string to a field as a default.
>
Paul,

Check a uniqueidentifier data type and NEWID function in BOL.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform