SQL Server Blogs

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

Browse by Tags

  • Extract only numbers from a String

    Sometimes we may need to extract only numbers from a string. Usually I see people using while loop to check each and every character to see if it is a number and extract it Here is a different approach Declare @s varchar ( 100 ), @result varchar ( 100 ) set @s = 'as4khd0939sdf78' set @result...
    Posted to Madhivanan (Weblog) by Madhivanan on Tue, Dec 18 2007
  • 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 (93 items) « First ... < Previous 6 7 8 9 10
Powered by Community Server (Commercial Edition), by Telligent Systems