Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Hi!,
Check if there is some code in the procedure dropping the table, because i've tried that way, and it works.
You can also create the table structure with the EXEC command,
see the books online for more information about the EXEC,
Also check the String that's being generated with the fields
You can use this exampe with the authors table on the Pubs database from Sql Server:
exec ('select Au_LName, Au_FName, Phone into tmpAuthors from Authors where State = "CA"')
It'll work, check it out.
good luck
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