swathi660

 Profile Answers by swathi660 

• Jan 15th, 2009

 

insert into t1 values(,,,) insert into t2 values(,,,) insert into t3 values(,,,,)......try this ........

krishna8081

 Profile Answers by krishna8081 

• Feb 24th, 2009

 

Here is the example for you question.

USE YourDB
GO
INSERT INTO
MyTable (FirstCol,
SecondCol)
SELECT ‘First’
,1
UNION ALL
SELECT ‘Second’
,2
UNION ALL
SELECT ‘Third’
,3
UNION ALL
SELECT ‘Fourth’
,4
UNION ALL
SELECT ‘Fifth’
,5
GO