Stored procedure problem 1

[stx]

Hi

This is my stored procedure...

create procedure get_tableInfo
(
@tablename char(8)
)

as
select * from @tablename
return


This doesn't work.
What i want to do is returning a selection on a table in my database. The name of the table is given as a parameter.
Any thoughts?

thnx

 

[ecobb]

Try this:

create procedure get_tableInfo
@tablename char(8)
as
select * from @tablename

 

[sunila7]

Hi,

u wwill have to use dynamic SQL...
Have a look a FAQ183-3132

Something like this....
create procedure get_tableInfo
@tablename char(8)
as
Declare @SQL Varchar(1000)

SET @SQL = 'select * from ' + @tablename
Exec(@SQL)

Sunil