In this article, we will see how to use @@IDENTITY and SCOPE_IDENTITY() in SQL Server 2012.
This article will explain the use of Sequence in SQL server and its advantages over an Identity column.
In this article I am explaining how to get the last inserted identity value of an auto increment column of database tables using SQL Server variable (@@IDENITY) and functions (SCOPE_IDENTITY() and IDENT_CURRENT()). Both @@IDENTITY and SCOPE_IDENTITY() return the last identity value that are produced in a single session; in other words a connection while IDENT_CURRENT() returns the last identity value according to the table for any session.
In this article I'll show you how to search a column value in all the referencing tables.
In this article we are show different types of joins in SQL Server. A Join in SQL is used to combine two or more tables. We use the Join operator to gather the data in a single query.
This article provides you different ways to implement a multi-criteria filtering.
Here you will see SQL Server Database Mirroring.
This article describes a simple approach to determining whether or not a logged in user is a member of a group within the context of a desktop application. The approach shown relies upon the use of the user’s current Windows identity.
This article lists some of the optimization tips for SQL Server development.
In this article you will see how to use conversion functions using SQL Query in SQL Server.
In this walkthrough we will see how to connect from Local SQL server management studio to SQL Azure. Follow the below steps.
Let's have a look to linked server concept in SQL Server.
Over the years, an increasing number of organizations have turned to Microsoft SQL Server because it embodies the Microsoft Data Platform vision to help organizations manage any data, at any place, and at any time. The biggest challenges organizations face with this increase of SQL Server installations have been in management.
In this article i will demonstrate Binary_Checksum, the Alternate of NewID() to fetch random records in SQL Server.
In this article I am going to explain how to create a shape in SQL server 2012.
In this article, I will show how to connect to a Data reader destination component within a given SQL Server Integration Services package.
This explains the good practices for writing stored procedures in SQL Server and the advantages of writing stored procedures.
In this article, I want to cover the new features in Oracle 11g and SQL Server 2008 database systems which are two important players always fighting for the top spot in this important market segment of the IT industry. By analyzing these two giants, we can see the trends in the database systems. It’s remarkable to say that I will analyze these database systems from the developer perspective.
In this article, I describe Views in SQL Server.
In this article we will bind three SQL Server tables with a TreeView in a hierarchical order