Posts

Showing posts from February, 2016

OUTPUT Clause with Insert in Stored Procedure in SQL Server.

Image
When you need Newly added Records ID from SP. Normally we tend to use @@Identity. Now this has Scope related issues.  To get Perfect Value for Inserted Record. We Can use OUTPUT INSERTED   SQL     GO /****** Object:  Table [dbo].[Table_1]    Script Date: 01/02/16 16:48:21 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo] . [Table_1] (        [ID] [int] IDENTITY ( 1 , 1 ) NOT NULL,        [Name] [varchar] ( 50 ) NOT NULL,   CONSTRAINT [PK_Table_1] PRIMARY KEY CLUSTERED (        [ID] ASC ) WITH ( PAD_INDEX = OFF , STATISTICS_NORECOMPUTE = OFF , IGNORE_DUP_KEY = OFF , ALLOW_ROW_LOCKS = ON , ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO     Create Proc spInsertReco...