Madhivanan

Moved my blog

Madhivanan — Tue, 02 Feb 2010 14:56:00 GMT

For all those reading my blog, for your information, I have moved my blog to http://beyondrelational.com/blogs/madhivanan Thanks to Simon for his support at sqlblogcasts.com...(read more)

Find alternate week day

Madhivanan — Tue, 12 Jan 2010 13:45:00 GMT

My co-worker had a task of finding minimum alternate week day as of today for a given date and day Consider these data Date : 2009-12-22 day : 5 (it denotes Thursday) It means the event was scheduled on 2009-12-22 which should run on every alternate Thursday...(read more)

Replace data of one table with data of other table

Madhivanan — Fri, 08 Jan 2010 11:26:00 GMT

One of the questions asked in a forum was about replacing data of one table by the data of another table The solution that the questioner used was having cursor by looping through the source table and replace particular words by other words from another...(read more)

Happy Holidays

Madhivanan — Thu, 31 Dec 2009 09:48:00 GMT

In the Query Analyser, set the Result mode to Text (Press CTRL+T) and run the following code set nocount on select space ( 17 - len ( replicate ( char ( 94 ), no )))+ replicate ( char ( 94 ), no * 2 - 1 ) from ( select top 10 row_number () over ( order...(read more)

Search a value in character column of all tables

Madhivanan — Mon, 14 Dec 2009 14:22:00 GMT

Sometimes, you may need to find a value in the characters columns (char, varchar, etc) in all the tables This is one of the methods to do it declare @sql varchar ( max ), @search varchar ( 100 ) set @sql = '' set @search = 'your search string'...(read more)

Removing unwanted characters - Part 2

Madhivanan — Wed, 02 Dec 2009 13:58:00 GMT

In my previous post about Removing unwanted characters , I posted a method that used a function Here is another method that uses Dynamic SQL declare @data table ( data varchar ( 100 )) -- table that has source data insert @data select 'tes^@&t...(read more)

Parsing a string

Madhivanan — Wed, 18 Nov 2009 09:03:00 GMT

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...(read more)

Usage of Semicolons in SQL Server

Madhivanan — Tue, 10 Nov 2009 09:37:00 GMT

As you know, semicolon is used as a statement terminator in almost all RDBMSs. However the usage of semicolon is optional in SQL Server except a few cases. Here are atleast the three cases where usage of semicolon is a must 1 At the start of the Common...(read more)

SQL Server 2008 features that work only in Enterprise Edition

Madhivanan — Tue, 03 Nov 2009 12:44:00 GMT

One of the new features available in SQL Server 2008 is compressed backup which takes backup of a database with mimimum possible size. The syntax is backup database db_name to disk = 'backup_path' with init , compression But this works only in...(read more)

Script out Procedures to seperate files

Madhivanan — Mon, 26 Oct 2009 09:34:00 GMT

In this post script-out-procedures-and-functions-part-2 , I showed how to script out the procedures in a single file Here is another way to do the same but different file for each procedure. The file name will be the name of the procedure. declare @sps...(read more)