Dear All,
I have one question regarding one query which i have made, i need to know that does the execution of this query will hinder some performance of sql server,reason is that this query will run continuously in some
interval of time... My Scenario is like this....
I have 2 databases
Demo1 with table Table1 with columns (id,name,value) where "id" is auto-incrementedDemo2 with table Table1 with columns (id,name,value) where "id" is auto-incremented
Now, My Active connection is with database "Demo1" and i am not changing the database connection or changing the database.
My Query work is to insert the data from Demo1 database to
Demo2 database. For this i have made the Query Like this: ...
Go to the complete details ...