In this article I am going to explain how to create a shape in SQL server 2012.

Today, I have provided an article showing you how to handle deadlock in SQL Server 2012.

Today, I have provided an article showing you an improved version of the execute keyword in SQL Server 2012.

Today, I have provided an article showing you how to insert multiple values into a table using a single query in SQL Server 2012.

In this article, let us see how to use the 3 new builtin conversion functions of Microsoft SQL Server 2012 Release Candidate 0 with their syntax and sample queries.

Today, I have provided an article showing you how to develop and design queries using the Query Designer in SQL Server 2012.

Today, I have provided an article showing you how to use the new Date and Time functions in SQL Server.

Today, I have provided an article showing you how to utilize the two new logical functions Choose() and IIF() in SQL Server 2012.

Today, I have provided an article showing how to use Sequence Object in SQL Server 2012. In this article we have also covered the difference between sequence and identity.

This article introduces how to Detach and Attach a database in SQL Server 2012 by using SQL Server Management Studio.

In a simple word we can say OUTPUT clause used with INSERT, UPDATE, or DELETE to identify the actual rows affected by these statements and also used for the auditing purpose.

This article shows how to use the EXISTS condition in SQL Server. The EXISTS condition is used to check if the row exists or not in the table. EXISTS queries are very inefficient since the sub-quer...

In this article, divided into two parts, I will compare the system function fn_listextendedproperty of SQL Server 2005 with the similar function of SQL Server 2000 ( Part 1 ), describe using the fu...

In this article, divided into two parts, I will compare the system function fn_listextendedproperty of SQL Server 2005 with the similar function of SQL Server 2000, describe using the function for ...

In this article I am going to talk about a cool new feature of SQL Server 2005 called CLR Integration, its advantages and how to program database objects using managed code with a simple project in...

In SQL Server 2005, CLR integration allows you to write stored procedures, triggers, user-defined types, and user-defined functions using any .NET Framework language, including Microsoft Visual Bas...

This article describes how to modify the team reports generated by VSTS or BI Studio over SQL Server 2005.

SQL Server Reporting Services is a comprehensive, server-based platform for creating, managing, and delivering reports that contain data from relational and multidimensional data sources. This arti...

The article provides details of various steps followed by author in upgrading ASP.Net 1.1 application to ASP.Net 2.0 and SQL Server 2000 to SQL Server 2005

This article is intended to show the principles and uses of cursors in relational database management systems. We’re going to discuss how cursors are implemented in Microsoft SQL Server and Oracle ...