How to create Dataset with Values Clause in SQL Server.


Posted on July 5th, 2015 by Hitesh Kumar | 653 Views 

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


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

Related posts:

  1. What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
  2. How to create Row Number Without Ordering Any Columns in sql server.
  3. What is First_Value Function in SQL Server?
  4. What is Last_Value Function in SQL Server?