how can we retrieve value from one database server and
store them another database server using sql server code
- 1 Answers
- 2279 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / Prithvee Raj Singh Parihar
To retrieve data from one SQL Server database and insert it into another, you can use the following steps: 1) Establish a connection to both databases. 2) Query the source database to retrieve the desired data. 3) Convert the result set into an appropriate format (e.g., ArrayList or DataTable). 4) Create a new connection to the destination database. 5) Execute an INSERT statement using SQL commands or ADO.NET (using SqlCommand, SqlConnection, and SqlDataAdapter objects) to insert the retrieved data into the destination database.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Define escape() function?
How to setting a cookie with the contents of a textbox?
How do you know if a set of points is a function?
how to get no of items from from weblist?
Write a main method that prompts the user to enter the starting population, birth and death rates, and the number of years. The input birth and death rates cannot be negative, the starting population cannot be less than 2, and the number of years greater than 0. If the user enters an invalid value, this program will prompt user to re-enter the value until a valid value has been read. When all input values are valid, call on the methods above to compute estimated population and print result.
Program to return the address family of a socket
Is it possible to do 301 redirects in javascript ?
How to convert a string to a number using javascript?
