I had this requirement today where I had to copy from a table in one database into a similar table in another database.
the code I have used in
[code]
insert into database1.dbo.table1 select * from database2.dbo.table1 where xxxxx
[/code]
where xxxx is the criteria that you need to add.
Precautions you have to tak before you do this.
Backup the database into which you are copying the record so that you can restore if something goes wrong.
Copy contents when there are no other transactions being entered into the database1
Subscribe to:
Post Comments (Atom)
Deploy the Azure Machine Learning Model
In the previous post I have discussed how to create an Azure Machine Model. In this post I will be discussing how to Deploy this model. Pre...
-
From the past 3 days I have been working on resolving merged and hidden cells issues when an SSRS reports is exported to excel. ...
-
I was trying to build an SSIS package that one of my colleagues has created. The first error that was thrown was as below: Exception des...
-
Today I was trying Node.js to connect to SQL Server, the connection to the sql server failed with the below error. name: 'ConnectionE...
No comments:
Post a Comment