To See Last Identity Inserted Values and Newid() function usage.

To See Last Identity Inserted Values and Newid() function usage:

A)Output Inserted.Id or Output Inserted.ColumnName--------> It Gives Last Column Inserted Values.

B)scope_identity() ---------> It Gives Last Identity Values.

C)NEWID()-----------------> It Gives New Unique Identifier Values.

D)Is a system function that returns the last-inserted identity value.

E)NEWSEQUENTIALID ------>Creates a GUID that is greater than any GUID previously generated by this function on a specified computer since Windows was started. 

A)To Make Last Identity Operations:

http://sqltechi.blogspot.in/2014/07/output-clause-in-insertupdatedelete.html

B)To See Last Identity Values:

C) Newid()

Output:
ABED2614-EA86-4379-9877-B31EC91B754B

It varies and gives new Unique identity values every time u ran Statements.

D)@@identity

E)NEWSEQUENTIALID: