how to insert the values in 5 table at a time Using any
single statement ?
Answers were Sorted based on User's Feedback
Answer / vishnu
It is not possible to insert multiple rows with a single
insert statement. If you want to insert multiple rows, one
have to write multiple insert statements considering that
you are working SQL server 2005 or it's below version.
But SQL Server 2008 allows to insert multiple rows with a
single insert statement.
As for example,
In sql server 2005, if we need to insert multiple row, we
used to do something like this.
CREATE TABLE [State] (
[StateID] int,
[StateName] VARCHAR(20)
)
GO
INSERT INTO State
VALUES (1, 'Gujarat')
INSERT INTO State
VALUES (2, 'Dehli')
INSERT INTO State
VALUES (3, 'Bihar')
But with SQL Server 2008 we can combine all the three insert
statement in single insert statement. See below:
CREATE TABLE [State] (
[StateID] int,
[StateName] VARCHAR(20)
)
GO
INSERT INTO State
VALUES (1, 'Gujarat'),
(2, 'Dehli'),
(3, 'Bihar')
Hope this helps...
Is This Answer Correct ? | 17 Yes | 1 No |
Answer / sitakanta rath
Sql Server does not support this. In sql server 2000 n 2005
we cant insert values in multiple tables at a single time.
Is This Answer Correct ? | 13 Yes | 1 No |
Answer / gvg
By Usngle statementing procedure we have to insert in a si
Is This Answer Correct ? | 14 Yes | 3 No |
Answer / pradeep kumar
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
Is This Answer Correct ? | 7 Yes | 2 No |
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
What are the advantages of user defined function?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....
9 Answers DELL, i Tech, Infosys, Siemens, TCS,
Does a specific recovery model need to be used for a replicated database? : sql server replication
What do you mean by normalisation?
how to delete duplicate rows from table in sql server
12 Answers HCL, UHG,
Can you tell me about the concept of ER diagrams?
what is a self join? Explain it with an example? : Sql server database administration
In the primary key have a multiple field or not?
What is dbcc updateusage?
Can I work with several databases simultaneously? : sql server management studio