Difference Between SCOPE_IDENTITY and atatROWCOUNT in sql server
SCOPE_IDENTITY
Returns the last identity value inserted into an identity column in the same scope. A scope is a module: a stored procedure, trigger, function, or batch. Therefore, two statements are in the same scope if they are in the same stored procedure, function, or batch.
ROWCOUNT"
Returns the number of rows affected by the last statement.
Dotnet, DotnetCore, Azure, C#,VB.net, Sql Server, WCF, MVC ,Linq, Javascript and React.js
Subscribe to:
Post Comments (Atom)
Find number of letter occurence of all letter in c#
Find number of letter occurence of all letter in c# namespace ConsoleApp1 { internal class Program { static void Main(st...
-
ViewBag, ViewData, TempData and View State in MVC ASP.NET MVC offers us three options ViewData, ViewBag and TempData for passing data from...
-
View in Sql Server 2008 Creates a virtual table whose contents (columns and rows) are defined by a query. Use this statement to create a vie...
-
// Export Datatable to Excel in C# Windows application using System; using System.Data; using System.IO; using System.Windows.Forms; ...
No comments:
Post a Comment
Comments Welcome