July 30, 2008 at 4:09 am
Can someone give me the code that could be used for collating tables and colums separately in SQL Server 2005?
July 30, 2008 at 4:18 am
You can set collations at these hierarchial levels.
server,database,columns. The server collation is default for the database and columns unless collations are modifed at any level. if you change the db collation then that becomes the default for the columns unless the column collation is changed. Ultimately data manipulation works at the column level.
if u want to compare data of 2 diff collations you can use the "collate" keyword along with cast/convert.
go thru BOL for more details. if u have a specific scenario pls provide the details.
"Keep Trying"
July 30, 2008 at 6:09 am
Just out of interest, having been through the world of pain that is changing the collations on columns of a table in a database that had a goodly few GB of data in it - WHY would you want to do this please?
Sorry, just the thought of this is bringing tears to my eyes, and memories of a looooong weekend at my keyboard
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply