Table Name as a variable 1

[Avacha]

I need to create Stored Procedure using Table Name
and Field Name as variables
If same one knows, please, help me with syntax.
I would greatly appreciate your help.

 

[vidru]

Here's a sample procedure with Table and Field as parameters that executes a query using dynamic SQL:

CREATE PROC MyProc
  @TableName VARCHAR(20),
  @FieldName VARCHAR(20)
AS

EXEC('SELECT ' + @FieldName+  ' FROM ' + @TableName)

To call it:

exec MyProc 'TableName', 'FieldName'

-dave

 

[vidru]

Arrrgh... cross post.... thread183-755468.

-dave