Get values from not defined table

• manig65

  SSC Enthusiast

  Points: 193

  More actions

  January 8, 2003 at 12:48 am

  #80108

  Hallo,

  Does anybody know how to make a function or stored procedure with input TABLENAME and value1. The output should be a selection from the given table (TABLENAME) and criteria value1. The problem is, I cann't declare te output table because i've more then 100 tables with variable number of collumns and collumn names.

  Also when it is impossible, please tell me

  thanks in advance

• Antares686

  SSC Guru

  Points: 125444

  More actions

  January 8, 2003 at 6:10 am

  #445832

  It requires you to use Dynamic SQL like so

  CREATE PROCEDURE ip_SP

  @tablename varchar(255)

  AS

  EXEC('SELECT * FROM ' + @tablename)

  or some other similar type of Dynamic SQL.