Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can not create the guid
Message
De
21/08/2001 10:51:42
 
 
À
21/08/2001 10:36:37
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
00546729
Message ID:
00546744
Vues:
16
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform