Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unanswered: Executing Large SQL statements


    I am trying to import a very large amount of data into an SQL database. The data is in a format of SQL statements already - it is all in one large text file consisting of a number of CREATE TABLE X and INSERT INTO X VALUES().

    The problem is that the amount of values being inserted into some of the tables is so large, that I am unable to open the .SQL file using query analyzer to run it, because the line-size limit for query analyzer is 64kb, whereas actual line-size in the file is in some cases in excess of 15MB.

    I would appreciate any advice on how to get all this data into a managable format. I keep thinking that there simply has to be a way to execute these over-size SQL statements.

    Thank you in advance!


  2. #2
    Join Date
    Aug 2002
    Try to open the .SQL file in NOTEPAD and scratch into manageble sizes for that statement.

    Or use OSQL utility to execute that .SQL file.
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts