ms sql database

sql return last inserted id scope identity

SQL Getting Last Inserted Id using SCOPE IDENTITY

  • by

SQL server Database as a function ‘SCOPE_IDENTITY()‘ which can be used to return the last created ID or Identity (Auto Incremented Primary Key) by the… Read More »SQL Getting Last Inserted Id using SCOPE IDENTITY

sql-stored-procedure-return-output-parameter-value 01

SQL Server – Stored Procedure returning output parameter

Let’s see a simple example on How we can return a parameter value using Stored Procedures in SQL server. SQL Stored Procedure Output Parameter Syntax,… Read More »SQL Server – Stored Procedure returning output parameter