Create table with name passed as parameter

• Mark Harley

  SSCrazy

  Points: 2259

  More actions

  April 3, 2006 at 7:44 am

  #167792

  Is it possible to create a new table with a stored procedure, using a table name that is passed into that procedure?  How is this done?

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  April 3, 2006 at 9:19 am

  #630449

  You would have to use dynamic sql...something like this...

  DECLARE @tableName varchar(50)

  DECLARE @sql varchar(500)

  SET @sql = 'CREATE TABLE ' + @tablename + ' (Col1 Int, Col2 VarVhar(50), Col3... )'

  EXEC(@sql)

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**