SQL Server TSQL

[jonsey]

Is it possible to create a parameter that allows a user to enter a table name which will be part of the select statement?
thanks

 

[sunila7]

Hi,

u could try something like this...
CREATE PROCEDURE new1 AS
Declare @tablename Varchar(40)
Begin
Declare @Sel as varchar(200)

set @Sel = 'Select * from ' + @tablename + ' Where field1 =''abcd'''
exec (@sel)
End


Sunil


GO

 

[jonsey]

i will try thank you