Answer / dhiraj kumar

we have to use INSERT INTO method.
with the use of this method we can easily transfer records
from one table to another table but both table should have
similar columns or you need to select same no of columns
and datatype as inserting table

example:table A1 having 2 columns emp_name,emp_address
and A2 having 4 column name,address,city,dept

INSERT INTO A1 select name,address from A2.

Answer / rajdeep gupta

Hi there is a question copy only schema without data from
one table to another

INSERT INTO A1 select name,address from A2 WHERE 1 = 2

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

Answer / gali kondareddy

INSERT INTO TABLE_2 SELECT * FROM TABLE_1


OR


INSERT INTO TABLE_2 SELECT * FROM TABLE_1 WHERE 1=1

Answer / abhik kumar basu

SELICT * INTO A1 FROM A2

Answer / rajeshbargode

we have to use INSERT INTO method.
with the use of this method we can easily transfer records
from one table to another table.we can not only use this
method in the same server but can aslo be done across the
server.for exmaple.if we have two table A1 and A2 then the
code is
INSERT INTO A2 select * from A2.

How to find related tables in sql server?

0 Answers  

How to create a dynamic cursor with the dynamic option?

0 Answers  

What are exact numeric data types in ms sql server?

0 Answers  

Is the primary key column of a table an index in ms sql server?

0 Answers  

1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder

3 Answers   CarrizalSoft Technologies, IBM,

CREATE TABLE [dbo].[HPMS_CompetencyTypes](CompetencyType varchar(50) ) go create trigger hpms_create_Insert on HPMS_CompetencyTypes for insert as if Exists ( select * from [HPMS_CompetencyTypes] where CompetencyType=(select * from [HPMS_CompetencyTypes])) begin Rollback tran Raiserror ('duplicate value',12,6) go insert HPMS_CompetencyTypes (CompetencyType) values ('new') I'm new to trigger can any one tell me where is the issue. Please.

2 Answers  

To find second largest salary in Employee table

17 Answers   CSS,

What is a View ? Can we insert, Update and delete a view?

0 Answers   Arigo Infotech,

What is SQL server agent?

2 Answers   HCL, SAP Labs,

when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

0 Answers  

What should we do to copy the tables, schema and views from one SQL Server to another?

3 Answers