update s set s.thisField = d.thatField, s.anotherField = d.andAnotherField from Table1 s, Table2 d where s.id = d.table1Id
Thursday, 23 December 2010
Updating fields in one table with fields in another
Subscribe to:
Posts (Atom)
C#, .Net, MVC, jQuery, JavaScript, HTML, CSS, Umbraco, Phonegap / Cordova, Xamarin, iPhone, iOS, Swift, Android, Windows, apps, websites, Full Stack, ecommerce, Facebook, responsive, front-end. Freelance developer, programmer for web and mobile in Bristol, UK.
Blog Archive
-
►
2017
(10)
- December (1)
- October (1)
- August (2)
- July (1)
- June (1)
- May (1)
- March (1)
- February (1)
- January (1)
-
►
2016
(27)
- November (2)
- October (1)
- September (1)
- August (1)
- July (2)
- June (4)
- May (3)
- April (1)
- March (6)
- February (5)
- January (1)
-
►
2015
(25)
- December (3)
- November (2)
- October (2)
- September (5)
- August (2)
- July (1)
- June (2)
- May (1)
- March (3)
- February (2)
- January (2)
-
►
2014
(28)
- December (5)
- November (3)
- October (1)
- September (4)
- June (2)
- May (4)
- April (2)
- March (1)
- February (4)
- January (2)
-
►
2013
(28)
- December (3)
- November (6)
- October (1)
- September (1)
- August (1)
- July (2)
- June (3)
- May (4)
- April (1)
- March (1)
- February (1)
- January (4)
-
►
2012
(38)
- December (2)
- November (1)
- October (1)
- September (3)
- July (1)
- June (5)
- May (1)
- April (3)
- March (7)
- February (8)
- January (6)
-
►
2011
(37)
- December (2)
- November (3)
- October (1)
- September (4)
- July (2)
- June (2)
- May (6)
- March (8)
- February (2)
- January (7)
-
▼
2010
(43)
- December (1)
- November (1)
- October (2)
- September (1)
- August (7)
- July (4)
- June (1)
- May (2)
- April (5)
- March (3)
- February (6)
- January (10)
Me, me, me, meeeeee
Ed Pitt - I'm a software engineer based in Bristol, which is in South West England, sort of near Bath and Cardiff :) Oh, and did I say I'm a freelance developer in Bristol, South West? And a freelance mobile developer in Bristol, South West? And I do C#.NET, MVC, Umbraco, Xamarin for Android and Windows Phones, iOS development, in Bristol, that's in the South West? And does this text sound like it's here just for SEO?
Contact me
Posts
Topics
- .net (10)
- 64-bit (5)
- accuracy (1)
- activerecord (2)
- Add-In Manager (2)
- Add-Ins (1)
- adestra (2)
- Adobe (1)
- affiliates (1)
- agile (1)
- ajax (8)
- Amazon AWS (1)
- analytics (2)
- anchors (1)
- Android (32)
- APNS (1)
- App Store (4)
- AppDomain (1)
- Apple (1)
- array (1)
- asp (1)
- asp.NET (12)
- automapper (1)
- BackgroundWorker (1)
- bandwidth (1)
- Bitbucket (1)
- blogger (1)
- BoundingBox (1)
- broadband (1)
- bugs (3)
- build events (1)
- c# (6)
- c#.net (10)
- caching (1)
- canonical tags (1)
- category filter (1)
- Certificates (1)
- Charles (1)
- chrome (1)
- CKEditor (1)
- collections (1)
- command line arguments (1)
- components (1)
- config (2)
- console (2)
- cookies (2)
- copy (1)
- cordova (15)
- CPC (1)
- cross browser (1)
- Crystal Reports (1)
- css (10)
- culture (1)
- currency (1)
- data attributes (1)
- datapager (1)
- datepicker (1)
- datetime (1)
- debugging (4)
- dell laptop (1)
- dell support (1)
- dependency walker (1)
- developer tools (4)
- Devise (3)
- dictionaries (1)
- directories (2)
- DisplayUnitSystem (1)
- dns (1)
- dns problems (2)
- DoEvents() (1)
- DX (2)
- Eclipse (3)
- ecplise (1)
- ElementSetIterator (1)
- elmah (1)
- email (1)
- Entity Framework (4)
- EpiServer (2)
- Error 404 (1)
- error capturing (1)
- events (2)
- ExactTarget (2)
- examine (3)
- facebook (3)
- family types (1)
- FCN (1)
- file associations (1)
- File Change Notification (1)
- file handling (3)
- file opening (1)
- file uploading (1)
- file versions (1)
- filters (1)
- fixture (1)
- Flurry (1)
- font (1)
- foreign key (1)
- format (1)
- friendly URLs (3)
- GCM (1)
- geometry (1)
- Git (5)
- github (1)
- Global.asax (1)
- google (2)
- Gov.uk (1)
- grammar (1)
- GridView (2)
- Guid (1)
- headspace (1)
- Heroku (1)
- hosting (1)
- html (3)
- HtmlTitle (1)
- https (3)
- i18n (1)
- IDE (2)
- IE (5)
- iframes (1)
- IIS (8)
- imagemagick (1)
- installation (2)
- installer (1)
- instance.name (1)
- iOS (18)
- iOS7 (1)
- iPhone (13)
- java (1)
- javascript (22)
- journal file (1)
- jQuery (7)
- jQuery Mobile (8)
- JSON (3)
- lambda queries (1)
- LAMP (1)
- language (1)
- leader (1)
- leaflet (2)
- LINQ (3)
- lists (1)
- listview (1)
- localization (1)
- lollipop (1)
- lucene (3)
- Mac (5)
- Mac OSX (1)
- mapping (1)
- maths (1)
- membership (2)
- menu (1)
- messagefocus (2)
- Microsoft (1)
- Microsoft Access (2)
- Microsoft Jet Engine (3)
- migrations (1)
- mobile (9)
- modal forms (1)
- msi (1)
- multi-threading (2)
- MVC (7)
- network (1)
- Newtonsoft (1)
- node.js (1)
- Norton Ghost (1)
- nuget (1)
- openstreetmap (1)
- P3P (1)
- page directive (1)
- pagination (1)
- parameters (1)
- phishing (1)
- Phonegap (17)
- plugins (1)
- Postgres (2)
- powershell (1)
- PPC (1)
- preprocessor directives (1)
- privacy (1)
- proxy (1)
- push (2)
- push notifications (4)
- Rails (18)
- random (1)
- RawUrl (1)
- Razor (2)
- recruitment (1)
- regedit (1)
- regex (1)
- repeaters (1)
- responsive design (1)
- restart (1)
- Revit (35)
- ribbons (1)
- Ruby (10)
- Rubymine (2)
- RvtMgdDbg (1)
- S3 (1)
- safari (4)
- scam (1)
- schedules (1)
- scrolling (2)
- selected elements (1)
- selection set (1)
- Sendgrid (1)
- seo (5)
- sessions (4)
- SetCacheability (1)
- setup (1)
- SharePoint (11)
- SharpZipLib (2)
- SIFR (1)
- signalR (1)
- sitemap (1)
- Skydrive (1)
- SMTP (2)
- software (2)
- Source control (1)
- sourcetree (2)
- speed (1)
- SPMetal (2)
- Spree (2)
- SQL (8)
- SQL Server (8)
- SQL Server Compact (2)
- SQLite (1)
- ssl (3)
- standards (1)
- Status codes (1)
- Stored procedures (4)
- strings (1)
- stylesheet (2)
- suo file (1)
- support (1)
- svn (1)
- swift (3)
- tab control (1)
- table owner (1)
- tablet (1)
- TestFlight (1)
- textnote (2)
- title tags (1)
- toolbar (1)
- tools (6)
- touch keyboard (1)
- tracking (2)
- Trade marks (1)
- Twilio (1)
- Twitter Bootstrap (2)
- type name (1)
- UDID (1)
- UITableView (1)
- Umbraco (4)
- unhandled exceptions (1)
- unit testing (1)
- units (1)
- updatepanel (1)
- URL rewriting (6)
- users (1)
- validation (2)
- validation groups (1)
- vanity URLs (3)
- versioning (1)
- views (1)
- Virgin Media (1)
- Visual Studio (11)
- VS2017 (1)
- web api (2)
- web user control (1)
- web.config (2)
- webforms (1)
- webview (2)
- windows (4)
- windows 10 (1)
- Windows Mobile (3)
- Windows Phone (3)
- winforms (1)
- WP8 (1)
- xamarin (20)
- Xcode (10)
- XML (3)
- zip (2)