Ispirer Ispirer
 


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

System table – syscomments

Compatability view should be upgraded to catalog view.

Microsoft SQL Server 2000:

 SELECT text FROM syscomments WHERE id = syscolumns.cdefault AND colid = 1

Microsoft SQL Server 2008:

 SELECT definition FROM sys.default_constraints WHERE object_id = sys.COLUMNS.default_object_id 

Column conversion:

Microsoft SQL Server 2000 (syscomments) Microsoft SQL Server 2008 (sys.default_constraints)
id object_id
text definition

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

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