Creating an index on a table variable

by

Can you create an index on a table variable in SQL Server 2000?

i.e. 

DECLARE @TEMPTABLE TABLE (
     [ID] [int] NOT NULL PRIMARY KEY
    ,[Name] [nvarchar] (255) COLLATE DATABASE_DEFAULT NULL 
)

Can I create an index on Name?

3 Answers
3

Leave a Comment