Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alemos
Starting Member
16 Posts |
 Posted - 2008-07-25 : 10:29:27
|
I found the INSERT GENERATOR script some time ago and I use is all the time. But today I needed to update a table on a second server, based on the data in the first server. I had to generate a bunch of update statements to do so (I can't link them in any way, different isolated networks) and run it in the second server.Does anyone know of or have an UPDATE GENERATOR script (procedure) like the Insert Generator?If not, I think I'll write one.  Thanks everyoneAécio Lemoshttp://www.vlsweb.com.brO primeiro provedor de hospedagem gerenciada do Brasil |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-25 : 10:57:30
|
| I use Excel whenever i needed to buid script like this. I'll copy data to cells and then use Concatenate function to join data with column names to form the script. then just use copy and apste formulas to get the script for other lines. then finally copy everything onto Query Analyser and execute. |
 |
|
|
|
|
|
Anyone have an UPDATE GENERATOR?