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
insert into database1.dbo.table1 select * from database2.dbo.table1 where xxxxx
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
I know of the following two ways to reset the identity of a table in sql server. You often tend to use dummy data during the course of y...
I have been in hibernation for too long now. I have changed jobs and now hjaving an opportunity to work on SAS code after nearly 11 years. ...
The following features cannot be saved in macro-free workbooks VB Project To save a file with these features, click no, and then choose ...