Answer Posted / mohamed ibrahim

To Copy the data from one table to another table
for ex . i have the table named as TempMaster that having
the fields ID ,Name .The having the following record
ID Name
1 Raja
2 Mohamed

I want the same record copy to TempMasterArcheived table

to copy this using the following code:
INSERT INTO TempMasterArcheived
EXECUTE
('SELECT * FROM TempMaster ')

ID Name
1 Raja
2 Mohamed

after the output of TempMasterArcheived is as follows

How you can change a cross join into an inner join?

1020

---

What are the limitations/drawbacks or ssrs 2008 r2?

152

---

Define right outer join?

1013

---

How to rename an existing column with sql server management studio?

1044

---

What happens to a trigger with multiple affected rows?

992

---

What is the osql utility?

1033

---

What are the different types of lock modes in sql server 2000?

992

---

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1093

---

Explain the properties of subqueries in sql server?

1132

---

Explain the difference between function and stored procedure?

993

---

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

1004

---

How to generate create function script on an existing function?

1170

---

What have included columns when we talk about sql server indexing?

1073

---

What are the different types of data sources in ssrs?

201

---

How to provide column names in insert statements in ms sql server?

1220

---