var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: 'Include clause' in Create Index syntax
What is the equivalent for INCLUDE clause (in Create index syntax) in SQL Server 2000.
SQL Server 2005 will support Include clause in Create index syntax . How to attain it in SQL Server 2000
Example : I have below query executable in SQL Server 2005
What is the equivalent for the above query in SQL server 2000
CREATE INDEX Index_Name ON mytable(col1 ASC) INCLUDE (name,id);
There is none. Include was new to 2005.
IS the closest. NOTE - you don't need to include any columns that are in your clustered index in the include - so if you cluster on ID you don't actually need it in the non-clustered index.
CREATE INDEX Index_Name ON mytable(col1, name,id ASC)
ur codings are working excelent.