Ispirer Ispirer
 


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

CollationPropertyFromId

Function CollationPropertyFromId required upgrade to CollationProperty:

Microsoft SQL Server 2000:

CollationPropertyFromId ( <collation_id>, 'sqlcharset')

Microsoft SQL Server 2008:

CollationProperty ( <collation_name>, 'sqlcharset')

Example:

Microsoft SQL Server 2000:

SELECT CollationPropertyFromID(col.collationid, 'sqlcharset')) FROM syscolumns col 

Microsoft SQL Server 2008:

SELECT CollationProperty(col.collation_name, 'sqlcharset')) FROM sys.COLUMNS col  

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

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