SQL Server Performance Forum – Threads Archive

Query Writing

How to write a query , which will copy a data from one table to another ?
Without using inner join ????? Mr. Shailendra Thaware
MCP Certified
www.withshailendra.netfirms.com
India,Maharashtra-Pune
Mobile No. 91-9890175282

---

I dont understand your question… You want to update some fields in table A, based on data in table B ?
Or do you want to insert rows from table B into table A? Im assuming its the first since you mention a JOIN, but what is your objection to using a JOIN ?

---

Could you be more specific?
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

---

Why not use DTS. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

I Couldn’t Get Your Question? Wat exactly u want to ask ?
Sandy (DB Developer)

---

INSERT table1(col1, col2)
SELECT col1, col2 FROM table2 ????
MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

---

SELECT *
INTO t2
FROM t1 — Marek ‘chopeen’ Grzenkowicz, MCP
Poland

---

]]>