Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Dynamic SQL Stored in a field
Message
De
27/02/2006 07:23:23
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Dynamic SQL Stored in a field
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01099394
Message ID:
01099394
Vues:
62
Is there a way to EXECUTE an sql statement stored in TEXT field w/o need to declare bunch of variables?
Because this script is very long (about 200K) I stored it in Text Field but I want to execute it. Now I declare about 25 variables (varchar (8000)) to read this field in them and then:
EXEC (@sql1+@sql2...)
maybe I missing something
TIA
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform