Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Versions des environnements
SQL Server:
SQL Server 2012
>>Hi Naomi,
>>That makes sense and I will give that a test run. I want to return the entire row back.
>>I appreciate it.
>
>Hi, Tim,
>
>Naomi's reply is exactly what you need, I just wanted to jump in with 2 more things.
>
>First, the OUTPUT statement has an optional OUTPUT INTO capability. So if you want to redirect the results of your insert (with the newly generated GUIDs and any other derived/calculated columns) to any table (including a temp table), you can. (The table has to exist...OUTPUT INTO won't create a new table on the fly for you)
>
>Second, just curious, since you're using SQL 2012 (which has the new Sequence Object). What's the reason for using a GUID? I realize it's a loaded question, just curious if the requirements call for it.
>
>Thanks...
We always use GUID's (uniqueidentifier) because we replicate our DB's across offices. Does the Sequence Object work with SQL replication?
Thanks
Sarosh
Précédent
Suivant
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