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