SQL Function Archives - Page 41 of 52 - SQL Authority with Pinal Dave

SQL SERVER – 2005 – Retrieve Any User Defined Object Details Using sys objects Database

March 16, 2008

SQL Function, SQL Scripts, SQL System Table, SQL Utility

sys.objects object catalog view contains a row for each user-defined, schema-scoped object that is created within a database. You can retrieve any user defined object details by querying sys.objects database. Let us see one example of sys.objects database usage. You can run following query to retrieve all the information regarding…

SQL SERVER – 2005 – What is CLR?

March 14, 2008

Pinal Dave

SQL

CLR, SQL Function, SQL Server, SQL Utility

CLR is Common Language Runtime.

Here is the diagram which explains the architecture of the CLR.

SQL SERVER – 2005 – Find Nth Highest Record from Database Table – Using Ranking Function ROW_NUMBER

March 12, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

MVP, SQL Function, SQL Joins, SQL Scripts

I have previously written SQL SERVER – 2005 – Find Nth Highest Record from Database Table where I have shown query to find 4th highest record from database table. Everytime when I write blog I am always very eager to read comments of readers. Some of regular readers are industry…

SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL – Part 3

March 11, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Function, SQL Joins, SQL Scripts

Please read SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL before continuing this article. I had asked users to come up with alternate solution of the same problem. Khadar Khan came up with good solution using CTE SQL SERVER – How to Retrieve TOP and…

SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL – Part 2 – CTE

March 10, 2008

Pinal Dave

SQL Tips and Tricks

CTE, SQL Function, SQL Joins, SQL Scripts, SQL Server

Please read SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL before continuing this article. I had asked users to come up with an alternate solution of the same problem. In this blog post we will see solution with the help of CTE.

SQL SERVER – Find Nth Highest Record from Database Table

March 8, 2008

Pinal Dave

SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server

I had previously written SQL SERVER – Query to Retrieve the Nth Maximum value. I just received an email that if I can write this using AdventureWorks database as it is a default sample database for SQL Server 2005 and the user can run the query against it and understand it better. Let us see how we can find highest record from database.

SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL

March 2, 2008

Pinal Dave

SQL Tips and Tricks

SQL Error Messages, SQL Function, SQL Joins, SQL Scripts, SQL Server

Just a day ago, while working with some inventory related projects, I faced one interesting situation. I had to find TOP 1 and BOTTOM 1 record together. I right away that I should just do UNION but then I realize that UNION will not work as it will only accept one ORDER BY clause. If you specify more than one ORDER BY clause. It will give an error. Let us see how we can retrieve top and bottom rows together.