Home Forums SQL Server 2005 T-SQL (SS2K5) pass table name as a parameter in stored procedure RE: pass table name as a parameter in stored procedure

  • you just write as:

    create procedure [dbo].[GetDataFromTable]

    (

    @tablename varchar(50)

    )

    as

    begin

    EXEC('Select * from '+@tablename)

    end

    this will give you whole data of that table which one name you passed in the parameter

    By:- Satish Pal