insert multiple rows..

[Goutam Patra]

Which database?

test-09 wrote:

other database(db2)

Database/table?

[test 09]

sqlserver 2005

test09

[Blue_Boy]

insert into table1 (columname1,columnname2) select columnmae1,columname2 from databasename.dbo.table2

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com

[test 09]

For all 400 rows i need to write the statements?? or any other way..

test09

[Blue_Boy]

That is basic query with which you can import records between tables but in select query it depends on your criterias.

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com

[test 09]

I am having the same db with 2 back ups both have different information(table rows) i need to append both..

test09

[Blue_Boy]

Did you try that query? I think you are trying to merge two databases into one, right?

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com

[test 09]

yes but i need to merge only one table..

test09

[Blue_Boy]

Then use my query and all will be done.

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com

[test 09]

using that query can insert single row how do i select all 400 rows.. or else i need to execute that query for each and every row..

test09

[Blue_Boy]

That query will insert all rows from table, not only one! Better check this http://en.wikipedia.org/wiki/Insert\_(SQL)

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com

[Mycroft Holmes]

He's in trouble if he is trying to merge 2 tables, there will be duplicates unless he filters them out.

Never underestimate the power of human stupidity RAH

[Mycroft Holmes]

Take the boys query and add a where clause that filters out existing records so you do not get duplicates. You need to identify the primary key (unique data) in both fields that can be used to apply the filter.

Never underestimate the power of human stupidity RAH

[Blue_Boy]

I warned him/her too in previos post, thanks for claryfing me :)

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com

[Mycroft Holmes]

Actually I think I could have left it a he's in trouble His level of understanding about database needs upgrading

Never underestimate the power of human stupidity RAH