Insert Data from a Table in another DataBase - Sql Server -



Insert Data from a Table in another DataBase - Sql Server -

insert customersnew (customername, country) select customername, country customersold status='n';

in above case can insert client info table "customersnew" exist in table customersold.

these 2 tables in same database

how perform same operation if these tables resides in 2 databases.

ex

table "customersnew" in db_new.

table "customersold" in db_old.

these 2 databases in 2 different locations.... how access security..(data bases have passwords......)

insert db_new.dbo.customersnew(customername, country) select customername, country db_old.dbo.customersold status='n'

sql-server sql-server-2008

Comments

Post a Comment

Popular posts from this blog

php - How to pass multiple values from url -

php - How to pass multiple values from url - i'm trying pass textbox , 1 select result value 1 page page.using url.but it's display error message. "parse error: syntax error, unexpected '' (t_encapsed_and_whitespace), expecting identifier (t_string) or variable (t_variable) or number (t_num_string) in c:.." while($value= mysqli_fetch_assoc($result)){ $apid=$value['apid']; echo("<tr> <td>". $value['apid'] ."</td> <td>".$value['email']."</td> <td>".$value['comments']."</td> <td>".'<input type="text" name="payment"/>'."</td> <td>"."<input type='text' name='apid' value='".$apid."' style='visibility:hidden' size='2'>"."</a>"."<a hre...
Read more

php - Laravel not returning controller -

php - Laravel not returning controller - i have simple ajax() request that's supposed add together coupon if take take (via pop tag). however, when run page , click on tag , @ in console it's doing returning entire page in html. how can utilize controller specify via routes? new ajax sure that's problem is. what's supposed happen client clicks on take coupon button, ajax processes info controller , shows modal letting them know coupon has been added successfully. a tag <a href="#" class="btn btndefault btnsmall" id="ajaxcoupon">add coupon cart , go on shopping <i class="fa fa-arrow-right"></i></a> ajax $('#ajaxcoupon').click(function(e){ e.preventdefault(); $.get('ajaxaddcoupon', function(data){ $('#successcoupon').foundation('reveal', 'open'); }); }); controller & route ...
Read more

c# - Confused on how to specify a Platform and Version while using ChromeOptions for RemoteWebDriver with Selenium donNet since recent updates -

c# - Confused on how to specify a Platform and Version while using ChromeOptions for RemoteWebDriver with Selenium donNet since recent updates - using c# selenium 2.39 , before, able interact chromeoptions , desiredcapabilities directly. so, if wanted emulate android device on modern version of windows, code snippet might this: // define chromeoptions create chrome deed mobile device chromeoptions options = new chromeoptions(); options.addargument("--user-agent=mozilla/5.0 (linux; android 4.0.4; galaxy nexus build/imm76b) applewebkit/535.19 (khtml, gecko) chrome/18.0.1025.133 mobile safari/535.19"); options.addargument("--disable-sync-passwords"); capabilities = desiredcapabilities.chrome(); //needed find win7 vm rather linux or mac capabilities.setcapability("platform", "vista"); //cef apps tested using selenium2 , grid. //a version of "real" has ...
Read more