how to pass sql commands using a text file

• eduinfo

  SSC Rookie

  Points: 45

  More actions

  January 5, 2002 at 12:06 pm

  #101061

  Hi is there any way by which i can run the queeires ina text file programmatically

• jG

  SSCrazy

  Points: 2505

  More actions

  January 7, 2002 at 7:13 am

  #421798

  Not sure about your specifics on using a text file, but one option, you could create your statements and call them through the ISQL utility. There are a few more options, but I would need to know what exactly you are trying to do. -JG

  
  -JG

• Brian Knight

  One Orange Chip

  Points: 27259

  More actions

  January 7, 2002 at 7:20 am

  #421799

  You can use the OSQL command with the -i (case sensitive) command. If you want to do it in T-SQL, then use xp_cmdshell followed by the osql command.

  Brian Knight

  bknight@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/bknight

  Brian Knight
  Free SQL Server Training Webinars

• eduinfo

  SSC Rookie

  Points: 45

  More actions

  January 7, 2002 at 9:09 am

  #421804

  Hi thanks for your help

  i do not want to use isql

  i want to do his using a programming language

  can this be done

  is there some sql command like

  run filename.sql

  thanks

  Sanket

• Brian Knight

  One Orange Chip

  Points: 27259

  More actions

  January 7, 2002 at 10:23 am

  #421822

  None that I'm aware of. You'd have to use the SP_OA* stored procedures if you want to do this programatically.

  Brian Knight

  bknight@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/bknight

  Brian Knight
  Free SQL Server Training Webinars

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737892

  More actions

  January 7, 2002 at 10:39 am

  #421826

  You can build a file using T-SQL and then run that via ISQL.

  Steve Jones

  steve@dkranch.net