Information générale
Forum:
Microsoft SQL Server
>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement