Sqlservercurry - sqlservercurry.com - Microsoft Sql Server Tutorials
General Information:
Latest News:
Using SUM OVER in SQL Server to Get % Sales 18 Aug 2013 | 01:52 pm
In some of our previous posts Aggregates without GroupBy SQL Server and SQL Server 2012 - Running total with SUM function, we have seen how to use SUM and OVER to calculate running totals and count w...
Throw Statement in SQL Server 2012 15 Jul 2013 | 06:27 pm
In SQL Server 2012, Microsoft introduced the THROW statement to throw error/exception during the execution of T-SQL program which will transfer the execution control to a CATCH block. Hypothetical Sc...
SQL Server 2012 Query Pagination 12 Jun 2013 | 11:05 pm
In SQL Server 2012, Microsoft introduced a couple of T-SQL Enhancements. One of them is Query Pagination which we will explore today. For this demonstration, I am using the Northwind database to demo...
SQL Server 2012 Query Pagination 12 Jun 2013 | 11:05 pm
In SQL Server 2012, Microsoft introduced a couple of T-SQL Enhancements. One of them is Query Pagination which we will explore today. For this demonstration, I am using the Northwind database to demo...
Get Temporary Table Column Names in SQL Server 1 Jun 2013 | 10:10 am
When a temporary table is created, a record gets created in tempdb’s sys.tables and tempdb.sys.columns system table. You can query these tables to get meta data information from a temporary table. He...
Get Temporary Table Column Names in SQL Server 1 Jun 2013 | 10:10 am
When a temporary table is created, a record gets created in tempdb’s sys.tables and tempdb.sys.columns system table. You can query these tables to get meta data information from a temporary table. He...
Finding Last Backup Date in SQL Server 2005 14 May 2013 | 09:37 am
I saw a question on the SO forums asking for a simple way to find the last backup date of a SQL Server 2005 database. Here's one approach. During a backup operation, the following tables are updated ...
Finding Last Backup Date in SQL Server 2005 14 May 2013 | 09:37 am
I saw a question on the SO forums asking for a simple way to find the last backup date of a SQL Server 2005 database. Here's one approach. During a backup operation, the following tables are updated ...
SQL Server NTILE Function 3 May 2013 | 02:48 pm
The SQL Server NTILE() function divides the result set into a specified number of even sized group (approximate division) and assigns a ranking value to these groups. The NTILE() function is similar ...
SQL Server NTILE Function 3 May 2013 | 02:48 pm
The SQL Server NTILE() function divides the result set into a specified number of even sized group (approximate division) and assigns a ranking value to these groups. The NTILE() function is similar ...
