https://wiki.ispirer.com/ 2026-07-26T06:42:21+00:00 https://wiki.ispirer.com/ https://wiki.ispirer.com/lib/tpl/dokuwiki/images/favicon.ico text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/upgrade/statementssyntax/dbreindex?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing Dbcc DbReindex DBCC DBREINDEX in fututre version is an option Rebuild in ALTER INDEX. Microsoft SQL Server 2000: DBCC DBREINDEX(<table_name>) WITH NO_INFOMSGS Microsoft SQL Server 2008: ALTER INDEX ALL ON <table_name> REBUILD text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/upgrade/statementssyntax/dropindex?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing Drop Index In future version changed syntax of DROP INDEX. Microsoft SQL Server 2000: DROP INDEX <table_name>.<index_name> Microsoft SQL Server 2008: DROP INDEX <index_name> ON <table_name> text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/upgrade/statementssyntax/fourpartcolumn?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing Four-part column references Some statements required additional manipulations to be used in newer version of MSSQLServer 2008. In SELECT statement Microsoft SQL Server 2000: select … from <database_name>.<schema_name>.<table_name> where <database_name>.<schema_name>.<table_name>.<column_name> = … text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/upgrade/statementssyntax/indexoption?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing 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 text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/upgrade/statementssyntax/joins-old-format?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing Joins in old format * Left Join * Right Join * Join with Constant text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/upgrade/statementssyntax/orderby-alias?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing Using alias in ORDER BY * Function after Column * Function before Column * DISTINCT and ORDER BY text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/upgrade/statementssyntax/table-hints?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing Table Hints without With Some statements required additional manipulations to be used in newer version of MSSQLServer 2008. Microsoft SQL Server 2000: select … from <table_name> (<table_hints>) Microsoft SQL Server 2008: select … from <table_name> WITH (<table_hints>) text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/upgrade/statementssyntax/threepartcolumn?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing Three-part column references Some statements required additional manipulations to be used in newer version of MSSQLServer 2008. Microsoft SQL Server 2000: select <schema_name>.<table_name>.<column_name> from <schema_name>.<table_name> Microsoft SQL Server 2008: text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/upgrade/statementssyntax/updatewithnolock?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing Update with Nolock at the From clause Using table hints without keywird WITH is deprecated in future versions. Microsoft SQL Server 2000 update <table_name> set …. from <table_name> as <alias_name>(NOLOCK) … Microsoft SQL Server 2008