How to create Dataset with Values Clause in SQL Server.


SELECT *
FROM (VALUES ('Hitesh','Kumar'),('Vikas','Shrivastava'),('Lalit','Sharma')) AS Employee(FirstName,LastName)


Query execution result:
FirstName LastName
Hitesh Kumar
Vikas Shrivastava
Lalit Sharma