3rd highest salary in sql server

How to see the values of a table variable at debug time in T-SQL?

SQL Server Query

DECLARE @DATE AS DATETIME
       SET @DATE = GETDATE()
SELECT @DATE as Todays

DECLARE @USERS AS TABLE(UserId INT, Name NVARCHAR(255))
       INSERT @USERS VALUES(1001, 'Anil Singh')
       INSERT @USERS VALUES(1002, 'Sunil Singh')
       INSERT @USERS VALUES(1003, 'Sushil Singh')

DECLARE @UserXML XML = (SELECT * FROM @USERS FOR XML AUTO)

SELECT * FROM @USERS
SELECT @UserXML as UserAsXML_Formatt


The output as see below

ANIL SINGH

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..
My Blogs - https://code-sample.com and https://code-sample.xyz
My Book1 - BEST SELLING ANGULAR BOOK (INCLUDING ALL VERSIONS 2, 4, 5, 6, 7)
My Book2 - ANGULAR 2 INTERVIEW QUESTIONS BOOK - Both Books are Available on WorldWide.

www.code-sample.com/. Powered by Blogger.