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
palsatish1
Valued Member
Points: 61
More actions
December 8, 2009 at 6:57 am
#1089181
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