Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unique STRING
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Miscellaneous
Thread ID:
00436401
Message ID:
00436427
Views:
26
>Hi,
>
>Anyone knows if it's possible to get a completely unique string from SQL Server? Like SYS(2015) from VFP?
>
>Thanks,
>
>Ric



NEWID (T-SQL) creates a unique value of type uniqueidentifier.
You can convert it into string as follow

SELECT CAST(NEWID() AS varchar(36))
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform