This is an old revision of the document!
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