Answer Posted / 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...

Can a table have 2 foreign keys?

905

---

What is difference between inner join and full join?

1067

---

What is the difference between delete and truncate statements?

1083

---

What is a non equi join?

981

---

What is the difference function and stored procedure?

1057

---

What is sql server transaction log file?

1054

---

Can you please explain the difference between primary keys and foreign keys?

1110

---

Can you insert NULL in unique column?

1161

---

Explain what is log shipping?

1136

---

What is rs.exe utility?

156

---

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2224

---

What are the differences between stored procedure and the dynamic sql?

1094

---

Explain the different types of joins?

997

---

What are key constraints?

976

---

What is difference between equi join and natural join?

1041

---