Ispirer Website Ispirer Capabilities - Microsoft SQL Server Migration Free Trial


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)

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.