Browse by Tags

changing collation of all columns without dropping them

Just this week I had opportunity to change collation of all objects using it in a database without dropping it. I like to computers to do what computers should do - work that is :). So I created a query that gave me script changing collation of all columns using collation - varchar, char and so on. I...

Posted to Piotr Rodak (Weblog) by Piotr Rodak on 12-14-2007
sorting trap

So, you might think that sorting within ASCII range is predictable and order defined by ASCII table is finite? You are on safe side when you do not use unicode nor 'fancy' letters? Well.. you are wrong. Recently I have been working on comparison of data stored in Sybase and SQL. Database structure is...

Posted to Piotr Rodak (Weblog) by Piotr Rodak on 11-03-2007

Page 1 of 1 (2 items)

SQL Server Community Blogs