Difference Between  @@identity , scope_identity() and ident_Current('tablename'):-

 SELECT @@IDENTITY
@@IDENTITY is limited to the current session, it is not limited to the current scope.


SELECT SCOPE_IDENTITY()


SELECT IDENT_CURRENT(‘tablename’)

IDENT_CURRENT is not limited by scope and session; it is limited to a specified table.  

Comments

Post a Comment

Popular posts from this blog

Export gridview into excel pdf csv   http://www.aspsnippets.com/ Articles/Print-functionality- in-ASP.Net- GridView -control. aspx  http://www.aspsnippets.com/ Articles/Export- GridView -To- Word-Excel-PDF-CSV-Formats-in- ASP.Net.aspx
Read more
How to insert multiple rows from c# table to sql database table:- Frontend:   <asp:Button ID="Button2" runat="server" Text="Create Table"             onclick="Button2_Click" /> <asp:GridView ID="gveg" runat="server">         </asp:GridView> Backend C#:  protected void Button2_Click(object sender, EventArgs e)     {         //         // Here we create a DataTable with four columns.         //                 DataTable temptable = new DataTable();         temptable.Columns.Add("ProductID", typeof(string));         temptable.Columns.Add("RelatedProductID", typeof(string));         temptable.Columns.Add("IsActive", typeof(string));         foreach (ListItem item in ListBox1.Items)         {             if (item.Selected)             {                 //                 // Here we add five DataRows.                 //                 temptable.Rows.Add(1, 1, 1);             }
Read more