SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » T-SQL (RSS)

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 Fri, Dec 14 2007
  • csv list of elements as parameter for stored procedure

    A while ago, Tony Rogerson showed a way how to pass a list of integers (csv) to stored procedure. Approach of creating a script and executing it is OK for smaller amounts of data. I thought, that maybe, as xml is a form of text after all, it would be more appropriate? I crafted a stored proc based on...
    Posted to Piotr Rodak (Weblog) by Piotr Rodak on Sat, Nov 24 2007
Page 10 of 10 (92 items) « First ... < Previous 6 7 8 9 10
Powered by Community Server (Commercial Edition), by Telligent Systems