You can't use a variable for a table or column name. However, you can dynamically create a SQL statement and execute it.
Create Procedure CreateNewIndex
@mytable nvarchar(40),
@indexname nvarchar(20),
@columns nvarchar(60) As
Declare @sql nvarchar(500)
Set @sql=
'CREATE INDEX ' + @indexname +
' ON ' + @mytable +
'(' + @columns + ')'
Execute @sql
----------------------
Stored procedure call:
Exec CreateNewIndex 'tblAddresses', 'LastName, FirstName' Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.