Intersection command in SQL Server

This function is used to returns distinct values that are returned by both the query on the left and right...

Last Weeks Top “Reading” Links #96

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

LEFT() function in SQL Server

Left():- This function returns the specified number of characters from the left part of the given character string.

Syntax:-

Select LEFT ( character_expression...

Let SQL Server Write Code for You

Introduction
Many times I happen to find myself in a situation where, as a DBA, I need to write some long...

Like() function in SQL Server

Like:- This operator is used in a WHERE clause to search for a specific pattern in the values of the...

New website

As you can see the webpage has changed!
New features are:

– Syntax highlighting on code snippets (and easy copy/paste)

– Better readability

–...

RIGHT() function in SQL Server

Right():- This function returns the specified number of characters from the Right part of the given character string.

Syntax:-

 Select RIGHT ( character_expression...

Speaking In Kansas City At #SQLSatKC

On Saturday, September 13th, I’ll be presenting my 10 Ways To Abuse T-SQL session in Kansas City. If you haven’t...

SQL Server 2005 || Database backup failed because Full Text catalog files are OFFLINE

Error : Database backup is getting fail with below reason.
The backup of full-text catalog ‘FullTextCatalog’ is not permitted because it is...

SQL Server 2005 || Database backup failed because Full Text catalog files are OFFLINE

Error : Database backup is getting fail with below reason. The backup of full-text catalog ‘FullTextCatalog’ is not permitted because it is not online. Check errorlog file for the...