Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to SQL Server Request SQLWays

Index Option without brackets

Some statements required additional manipulations to be used in newer version of MSSQLServer 2008.

Microsoft SQL Server 2000

CREATE INDEX <index_name> ON <table_name> ( <column_list>) WITH PAD_INDEX

Microsoft SQL Server 2008

CREATE INDEX <index_name> ON <table_name> ( <column_list>) WITH (PAD_INDEX = ON)

Ispirer Home Page Ispirer SQLWays Product Page - Migration to SQL Server Request SQLWays

sqlways/sql-server/upgrade/statementssyntax/indexoption.txt · Last modified: May 07, 2018, 03:15:34 PM (external edit)
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement