File input into T-SQL script?

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  May 29, 2003 at 11:41 pm

  #459150

  Not to sure about the first option but you could load the file into a table or variable (VARCHAR(8000)) max.

  Have a look at BULK INSERT in BOL.

  Cheers,

  Crispin

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!