SQL Server Blogs

Now-a-days lot of questions are asked in the forum about extracting particular text from a string Here I give some examples on how to do it --Example 1 (Extracting tags and other informations) declare @s varchar ( 100 ) declare @temp table ( id int identity ( 1 , 1 ), data varchar ( 100 )) set @s = '567<a>data<fg>ua<li>test<iu>welcome'...

In http://ask.sqlteam.com , a question was asked about removing the comments from the HTML template The comments have the following pattern {/*}comment{*/} The comments can be nested too The task is to remove all the comments Here is my solution declare @string varchar ( 8000 ) , @data varchar ( 8000...

One of the posters asked a question in the forums about finding a number in an expression consists of alphabets and number if a particular digit is provided Consider the following set of data this is test place located at no 123456 test foo 35234 bar 126831 72348707 foo foo 987654 bar If the digit provided...