Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Quick SQL/.Net Question
Message
Information générale
Forum:
ASP.NET
Catégorie:
ADO.NET
Titre:
Quick SQL/.Net Question
Versions des environnements
Environment:
VB 8.0
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01192408
Message ID:
01192408
Vues:
59
Does anyone know what the limit (if any) the text is that you can pass to the Command object for SQL queries? Basically, I wanted to add the ability to take a script file that may have any combination of CREATE, ALTER, INSERT, DELETE, etc... commands and process them all. Problem is that I have no clue how big these script files may get...they could theoretically get pretty big, and I was curious what the sting limit was that I can pass was.

Also...has anyone else attempted to do a similar thing as this in their apps..I mean allowing you app to accept script files and process them against a SQL database?
________________________
Ben Santiago, MCP & A+
Programmer Analyst (SQL, FoxPro, VB, VB.Net, Java, HTML, ASP, JSP, VBS)
Eastern Suffolk BOCES - Student Data Services


Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
-Rich Cook
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform