quick and easy way of adding multiple rows into a table using one INSERT INTO statement
insert into @table (a,b,c)
select 'who', 'what','when'
union all
select 'why','how','mom'
quick and easy way of adding multiple rows into a table using one INSERT INTO statement
insert into @table (a,b,c)
select 'who', 'what','when'
union all
select 'why','how','mom'