Passing Table Names into a large script

• Chris Kitchen

  Hall of Fame

  Points: 3090

  More actions

  March 8, 2007 at 8:43 am

  #153467

  Hi,

  I'm running SQL Server 2000 SP3a on Windows 2003 Advanced Server. I have a large script that creates a trigger.  The script requires the table name to be added three times throughout the script.

  I am wanting to run this script against 200 tables in the same database, and therefore would like to be able to pass through the table name to the script.  I have a separate table that contains all the table names I want to pass through to the script.

  As the script contains "create trigger ....." I cannot put the code within a stored procedure and pass the table name through.

   

  Any ideas?

   

  Thanks in advance.

  www.sqlAssociates.co.uk

• mrpolecat

  SSCertifiable

  Points: 7014

  More actions

  March 8, 2007 at 12:52 pm

  #693909

  use vbscript to create and execute the sql

   

   

  ---

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  March 8, 2007 at 2:38 pm

  #693942

  I cannot put the code within a stored procedure and pass the table name through.

  No, you can.

  Just use dynamic SQL.

  Put @TABLENAME@ in your script instead of actual table name.

  SET @SQL = REPLACE(@SQL, '@TABLENAME@', @TableName)

  EXEC (@SQL)

  _____________
  Code for TallyGenerator