Effects of sp_rename on Stored Procedures

There comes a time when mistakes are made.  Sometimes those mistakes can be as annoying as a spelling mistake during the creation of a stored procedure.  When a mistake...

Export XML Columns to Individual Files

I was reading SqlServerCentral.com Articles Requested forum and saw this request.
Looking for an article that takes data from an XML...

Guest Post on SQL Authority – Default Trace & Deleted Databases

I had the opportunity to write another guest post at SQL Authority:
Finding Out What Changed in a Deleted Database
This one...

IN clause in SQL Server

With IN clause, we can specify multiple values in a WHERE clause.

For example, in case of "IN", one can use...

LEN() function in SQL Server

LEN():- This function is used to get the length of the given string value.

  Syntax:-

    Select len (stringvalue)

  For example,

   ...

LOWER() function in SQL Server

LOWER():- This function is used to convert the value of a column to lower case

 Syntax:-

 Select LOWER (string)
 
 or
 
 SELECT LOWER(column_name) FROM table_name

For...

LTRIM() function in SQL Server

LTRIM ():- This function is used to get the string after the removal of leading blank spaces.

Syntax:-

LTRIM ( character_expression )

For example:-

Select LTRIM ...

MDX Time Calculations Built to Scale

When creating time calculations in Analysis Services you may take several approaches. For people that have just begin learning SSAS...

MDX Time Calculations Built to Scale

When creating time calculations in Analysis Services you may take several approaches. For people that have just begin learning SSAS...

More than sp_help

If you have worked with SQL Server for very long you have probably run across the extremely useful system function...