Archive

Archive for October, 2012

What is “BEGIN…END” in SQL Server

“BEGIN…END” is used to create the body for the flow-control statements like IF..ELSE or WHILE…, etc. in SQL Server.

Here is an example of it with IF…ELSE statement.

Read more…

Advertisements

What is “GO” keyword in SQL Server

In simple words, the “GO” keyword in SQL Server is T-SQL batch indicator. It’s optional for user to write in T-SQL batch. Then, why do we have it? What is the significance of it? Okay. Let me explain it.

If we write following three queries in SSMS and press Execute button, it gives us three separate result sets in Results tab as shows below.

Read more…

SQL Server 2008 Programming Training at Analytics Quotient, Bangalore, Oct 15th – Oct 29th, 2012

Enjoyed a lot…especially batch time i.e. 7:30 AM – 4:00 PM…:)

SSIS & SSAS Training at Manhattan Associates, Bangalore, Oct 8th – Oct 12th, 2012

SSIS & SSAS Training at Manhattan Associates, Bangalore, Oct 8th – Oct 12th, 2012