Sally1053
Last Activity: Sep 21 '07, 07:38 AM
Joined: Sep 6 '07
Location:
-
Sally1053 started a topic how do you use XML to store your data and then call it to update database in SQLin SQL Serverhow do you use XML to store your data and then call it to update database in SQL
how to u use XML to store or save data and then how are you going to call it to be able to update database server -
Sally1053 started a topic hoe do you use XML to store your data and the call it to update database in SQLin SQL Serverhoe do you use XML to store your data and the call it to update database in SQL
guys help me on how to put data in an XML of file somewhere and call it to update the database server. and how to you go about calling the data to update the database server -
Sally1053 started a topic how to call database stored in a file to update the other database on SQL Serverin SQL Serverhow to call database stored in a file to update the other database on SQL Server
My task is to take a database from one machine(X)and put into my machine(Y), maybe in a file or XML and retrive data from it to insert or upate the database on my machine(Y), This databases must use or have same names.
So my problem is how do I show the path on my procedure to call that database from the file or implement it in XML ?
Please if anyone knows help out because my boss need this as yerste... -
Thank you for your response, But my problem is not resolved yet, What im actually trying to do is to take data from Another DB-TLC to DB-Test. And these two database they are not integrated and we can't intergrate them.So what will happen is: if the data exist it can update else insert a new record. I'm not creating database from scratch.
this error is trigged by these statemement
IF @BlasterID <> (select BlasterID... -
Sally1053 started a topic Do you understand this Error msg (ERROR Msg 512, Level 16, State 1, Line 33)in SQL ServerDo you understand this Error msg (ERROR Msg 512, Level 16, State 1, Line 33)
I have created a procedure which start by fecthing data from DB-X and put in into the temporary memory. what im trying to do now is to take data from temporary memory insert/update DB-Y.
But now I get this ERROR Msg 512, Level 16, State 1, Line 33
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
... -
use fetch to retrieve and then update or insert into another DB table
I want to write a fetch statement to retrieve data in database1 and then go to another database2 to update or insert the records table -
cursor and fetch statement
can you please give me an example of using the FETCH and cursor statement
And make to be able to fetch more that one row at a time,
lets say the two database are TEST(fetch to) and TLC (fetch from) and both have Table called Mine with same fields -
can you please give me and example of using the FETCH and cursor statement
And make to be able to fetch more that one row at a time,
lets say the two database are TEST and TLC (fetch from) and both have Table called Mine with same fieldsLeave a comment:
-
use fetch to retrive and then update or insert into another DB table
I want to write a fetch statement to rtrieve data in database1 and then go to another database2 table to update or insert the records -
update or insert data from one table to another
i have been given a task, where i have to write a query that will take data from a certain database1 table and update the records in the database2 tables or insert new record
how do i do that?
and can one explain for me how the fetch statement works If i have to use to resolve my problem?
No activity results to display
Leave a comment: