-
Insert Data in Multiple Tables
How to insert data in multiple tables at same time. using SQL Server 2000
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
swathi660
- Jan 15th, 2009
Insert into t1 values(,,,) insert into t2 values(,,,) insert into t3 values(,,,,)......try this ........
-
SQL Server Insert and Delete
1. how to insert five rows in a table using single query(in ms-sql or oracle)2.how to delete duplicate values in a table. for example, the table containing five duplicate values(like name rani). i would like to delete all four rows in a table. but not the one row.
psingla
- Mar 19th, 2010
As suggested by krishna create table test_a(a int)insert into test_a values(1)insert into test_a values(1)insert into test_a values(3)insert into test_a values(4)insert into test_a values(5)inser...
clickfreehit
- Apr 11th, 2009
Inset data:insert into targettableselect top 5 * from sourcetabledelete data:1. select distinct * into targettable from sourcetable2. delete from sourcetable3. insert into sourcetable select * from targettable
