This blog shows a way to examine table's column values and drop columns that have nothing but NULL values in them....

This is a short blog post for the problem I solved today in MSDN forum. The task was to remove all bad chars from a string allowing only good characters (spaces, letters and numbers). I solved it using a PATINDEX function and wh...

0 BEGIN SET @Rest = Substring(@String,@nBadChars + 1,Len(@String)) SET @S......

This blog post will present a T-SQL solution for a 'cleansing' problem. Suppose, we need to remove all commas, single and double quotes from all character fields in a table....

0 --......

This blog will show how to search for an integer value in all integer (smallint, tinyint, int, bigint) columns in all tables in the database....

A new MSDN thread question prompted me to write a new variation of my original blog post 'How to search a string value in all columns in all tables in a database'. This blog will show how to search for an integer value in all integer (smallint, tinyint...

One of the common questions I encounter in the different SQL related forums is "How to search all columns in all tables in the database". My usual answer is to refer people to the Question #2 in th...

One of the common questions I encounter in the different SQL related forums is "How to search all columns in all tables in the database". My usual answer is to refer people to the Question #2 in this blog The ten most asked SQL Server questions. However...

When I wrote my first article with the same name here, Interesting T-SQL problems,&n...