Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can not create the guid
Message
From
21/08/2001 10:51:42
 
 
To
21/08/2001 10:36:37
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00546729
Message ID:
00546744
Views:
15
>Help. We are creating a script which will create and setup all SQL7 tables for a customer who purchases our software. Once the software is purchased we will not have the access to their SQL server. The problem that we are having is, the script will not create the guid. The script does not error but when the tables are created there is no guid. What am I doing wrong, is there a parameter that needs to be turned on or off inside the script to allow for a guid to be script generated or what?

You mean that the column for the guid is not added to the table, or that it ends up being another data type, or that the unique identifier is not generated when you add records?

If it's the last case, you have to create it with a DEFAULT constraint calling the NEWID() function.
Previous
Reply
Map
View

Click here to load this message in the networking platform