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 MoreSQLAuthority News – SQL Server White Paper: SQL Server 2008 Compliance Guide
Note: Download White Paper by Microsoft Organizations across the globe are being inundated with regulatory requirements. They also have a strong need to better manage their IT systems to ensure they are operating efficiently and staying secure. Microsoft is often asked to provide guidance and technology to assist organizations struggling…
Read MoreSQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database
SQLAuthority Blog reader YordanGeorgiev has submitted very interesting SP, which uses cursor to generate text of all the Stored Procedure of current Database. This task can be done many ways, however, this is also interesting method. USE AdventureWorks GO DECLARE @procName VARCHAR(100) DECLARE @getprocName CURSOR SET @getprocName =Â CURSORÂ FOR SELECT s.name…
Read More
SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Group Photo
MVP Open day 2008 is one of the best event happened so far. I have previously written about this event in detail on this blog.