Many times when I am writing query I have to scroll the result displayed in the result set. Let us learn about the shortcut today.
SQLAuthority News – Download Tools and Documentation for SQL SERVER
SQL Server 2008 Report Definition Language Specification The goal of Report Definition Language (RDL) is to promote the interoperability of commercial reporting products by defining a common schema that allows interchange of report definitions. An important aspect to understand is that RDL is a schema definition, not a programmatic interface…
Read MoreSQLAuthority News – Help to Find Recession Proof Job
Recently I have been receiving a lot of emails from employees asking where they can find good employee. I was under impression that due to global recession job market is down but from looking at recent increase in emails for looking for right candidate I have to say that there…
Read MoreSQLAuthority Author Visit – Ahmedabad SQL Server User Group Meeting – November 2008
It is time again to announce SQL Hour – SQL Server User Group Meeting for November 2008. This time it is going to be one really interesting event. Our User Group is growing and getting more interesting. Lots of new SQL Server enthusiastic have contacted me recently for User Group…
Read MoreSQL SERVER – Interesting Observation about Order of Resultset without ORDER BY
Today I observed very interesting little thing about SQL Server and I felt that I should share this with my readers. I ran following two queries and found that I am getting different result-set. When I carefully observed I found that actually the result was same but order of the…
Read More
SQL SERVER – 2008 – Download and Install Sample Database AdventureWorks 2008
The following sample database is currently available for Microsoft SQL Server 2005 and Microsoft SQL Server 2008:
SQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database Including Schema
I love active participation from my readers. Just a day ago I wrote article about SQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database. I just received comment from Jerry Hung who have improved on previously written article of generating text of Stored Procedure. DECLARE…
Read More