Home › SQL Server

SQL Server - Using Row Constructors


Row Constructor Example

DECLARE @emp TABLE (
	FirstName VARCHAR(20), 
	LastName VARCHAR(20)
)

-- Using Row Constructors
INSERT INTO @emp (FirstName, LastName)
VALUES 
	('Jacob', 'Sebasian'),
	('Bob', 'Jones'),
	('Doe','Jane')
	
SELECT * FROM @emp
/*
FirstName            LastName
-------------------- --------------------
Jacob                Sebasian
Bob                  Jones
Doe                  Jane
*/

Share |
 Cant find the page you are looking for?
 Help us to improve by adding the content that you are looking for.
 Leave a feedback
 We look forward to hear your comments and feedback.