Substring() function in SQL Server

Substring():- This function is used to return the specified number (third argument "len") of characters from a given string(first argument)...

UPPER() function in SQL Server

UPPER():- This function is used to convert the value of a column to upper case.

 Syntax:

   SELECT UPPER(string)

OR

Select UPPER(Column name)...

AND and OR Operator in Sql Server

And & Or:- These Operators are used to further filter the recordset return by SQL queries when more than one conditions...

Max() function in SQL Server

Max():- This function gives the maximum value of the selected column

Syntax:-

Select Max (col1) from table_name

In this article, we are...

One of Those Must Read Books – The Cuckoo’s Egg

I was reading a book about network security monitoring and it mentioned The Cuckoo’s Egg by Cliff Stoll. Stoll’s book has been...

RTRIM() function in SQL Server

RTRIM():-This function is used to get the string after the removal of all trailing blanks.

Syntax:-

RTRIM ( character_expression )

For example:-

Select RTRIM('Vivek Johari ...

Say Thank You

I was approached by a man at SQL Bits who only wanted to thank me for blogging. He said, “I...

SQL Server for VM Admins vBrownBag Webinar

Next Wednesday, August 20th, at 7:30pm Central I will be presenting a webinar for the Professional VMware #vBrownBag entitled “SQL...

Tableau Conference Is Bigger Than PASS Summit

I was reading http://paultebraak.wordpress.com/2014/08/11/the-wisdom-of-the-tableau-crowd/ and, no disrespect intended at all to the Tableau universe,  I was astounded to see that...

The Murder Train chugs into Denver!

You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get...