TSQL layered inserts

Question

Got a request in this format for importing data ... is there any equivalent in TSQL where you will need to use "insert into blah" once? (so that I can convert this script)

insert into marital_status (id,description) 
values
   (1,'Married'),
   (2,'Separated'),
   (3,'Never Married'),
   (4,'Divorced'),
   (5,'Widowed'),
   (6,'Co-Habitation'),
   (7,'No Response')

Answer 1

This is a T-SQL script - for Server 2008 - do not forget in 2005 that you do not have this feature: - (

You need to write this query as follows:

insert into marital_status (id,description) 
values(1,'Married')
insert into marital_status (id,description) 
values(2,'Separated')
insert into marital_status (id,description) 
values(3,'Never Married')
insert into marital_status (id,description) 
values(4,'Divorced')
insert into marital_status (id,description) 
values(5,'Widowed')
insert into marital_status (id,description) 
values(6,'Co-Habitation')
insert into marital_status (id,description) 
values(7,'No Response')

Answer 2

Another variant:

insert into marital_status (id,description) 
    SELECT 1,'Married'       UNION ALL
    SELECT 2,'Separated'     UNION ALL
    SELECT 3,'Never Married' UNION ALL
    SELECT 4,'Divorced'      UNION ALL
    SELECT 5,'Widowed'       UNION ALL
    SELECT 6,'Co-Habitation' UNION ALL
    SELECT 7,'No Response'