Friday, 11 August 2017

IDENT_CURRENT SQL Server

IDENT_CURRENT returns newly inserted record‘s auto increment value. So you can use this data while inserting a record it can be useful in many times. For example you want to return newly inserted record is for other task etc.


 USE [girfa]
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:        Raj Kumar
-- Create date: 08-Aug-2017
-- Description:   Girfa Student Help
-- =============================================
alter PROCEDURE [dbo].[adddata]

(@name nvarchar(20),@city nvarchar(20))
     
AS
BEGIN
       declare @id varchar(20)
       insert into stu (roll,name,city)
       values('Girfa'+ CONVERT(varchar(10),IDENT_CURRENT('[dbo].[stu]')),@name,@city)
       
       
end