Anil Singh | Code-sample.com

The DATEDIFF function is use to get the differences in days, hours, minutes, seconds etc. and  It is returns the time between two dates. The DATEDIFF function can be used from above version of SQL Server 2005. --Syntax DATEDIFF(DATE_PART, START_DATE, END_DATE) --Types of, SELECT DATEDIFF( DAY , GETDATE(), GETDATE() + 1 ) AS DAY_DIFFERENCE SELECT DATEDIFF(WEEK, GETDATE(), GETDATE() + 1 ) AS WEEK_DIFFERENCE SELECT DATEDIFF(HOUR, GETDATE(), GETDATE() + 1 ) AS HOUR_DIFFERENCE SELECT DATEDIFF( MINUTE , GETDATE(), GETDATE() + 1 ) AS MINUTE_DIFFERENCE SELECT DATEDIFF( SECOND , GETDATE(), GETDATE() + 1 ) AS SECOND_DIFFERENCE -- Example as, SELECT DATEDIFF( YEAR , '2015/04/28' , '2016/04/28' ); --RESULT is: 1 SELECT DATEDIFF(YYYY, '2015/04/28' , '2016/04/28' ); --RESULT is: 1 SELECT DATEDIFF(YY, '2015/04/28' , '2016/04/28' ); --RESULT is: 1 SELECT DATEDIFF( MONTH , '2015/01/01' , '2016/04...

What is @@IDENTITY in SQL? The @@IDENTITY is a system function which returns the last inserted identity value. All the @@IDENTITY, SCOPE_IDENTITY and IDENT_CURRENT are similar functions because all are return the last inserted value into the table’s IDENTITY columns. The @@IDENTITY and SCOPE_IDENTITY return the current session last identity value but the SCOPE_IDENTITY returns the current scope value. What is the scope of @@IDENTITY? In the @@IDENTITY, there are no any limitations for a specific scope. Syntax : - @@IDENTITY    Return Type : - numeric ( 38 , 0 ) For example as, -- USE OF @@IDENTITY INSERT INTO ContactType(Code, Description, IsCurrent, CreatedBy, CreatedOn) VALUES ( 'IT-PROGRAMING' , 'This is a Prrogrammer!' , 1 , 'Anil Singh' , GETDATE()); GO SELECT @@ IDENTITY AS 'COL_IDENTITY' ; GO The Use of  SCOPE_IDENTITY :- -- DECLARE RETURN TABLE DECLARE @Return_Table TABLE (Cod...