如何在表变量上创建索引? [英] How to create an index on table variable ?
问题描述
嗨朋友,
我有一个表变量
DECLARE @TBL TABLE(ID INT PRIMARY KEY,......,FROMDATE DATETIME,TATEATE DATETIME)
我想在FromDate和ToDate上创建NON-Clustered Index,如下所示
在@TBL上创建非聚集索引fdate_idx(fromDate)
但是有错误
附近的语法不正确....
请解决这个问题
提前致谢
shreeniwas
< pre lang =SQL> DECLARE @ TBL TABLE (ID INT PRIMARY KEY ,FROMDATE DATETIME ,TODATE DATETIME , UNIQUE NONCLUSTERED (ID,FROMDATE))
检查以下链接
在表变量上创建索引 [ ^ ]
在SQL中索引表变量服务器 [ ^ ]
表变量的索引 [ ^ ]
问候,
GVPrabu
Hi Friends,
I have a table variable
DECLARE @TBL TABLE(ID INT PRIMARY KEY,......,FROMDATE DATETIME,TODATE DATETIME)
I want to create NON-Clustered Index on FromDate and ToDate as folows
create nonclustered index fdate_idx on @TBL(fromDate)
but there is an error
incorrect syntax near....
Please resolve this problem
Thanks in advance
shreeniwas
Hi,
DECLARE @TBL TABLE(ID INT PRIMARY KEY,FROMDATE DATETIME ,TODATE DATETIME, UNIQUE NONCLUSTERED (ID, FROMDATE))
Check the following links
Create Index on Table Variable[^]
Indexing Table variables in SQL Server [^]
Indexes on Table Variable[^]
Regards,
GVPrabu
这篇关于如何在表变量上创建索引?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!