<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://msmvps.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Think you know how to write UPDATE statement? Think again.</title><link>http://msmvps.com/blogs/omar/archive/2007/01/20/think-you-know-how-to-write-update-statement-think-again.aspx</link><description>When I was a kid, my mom used to read me UPDATE queries every night before I went to sleep. I heared many stories about updating objects to database where most of them were the same old: UPDATE [ Table ] SET Field1 = Value1, Field2 = Value2, . . . WHERE</description><dc:language>en</dc:language><generator>CommunityServer 2008.5 SP2 (Build: 40407.4157)</generator><item><title>re: Think you know how to write UPDATE statement? Think again.</title><link>http://msmvps.com/blogs/omar/archive/2007/01/20/think-you-know-how-to-write-update-statement-think-again.aspx#1695092</link><pubDate>Fri, 12 Jun 2009 07:21:27 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1695092</guid><dc:creator>kristin davis sex tape</dc:creator><description>&lt;p&gt;Only with guarantee best kristin davis sex tape&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1695092" width="1" height="1"&gt;</description></item><item><title>re: Think you know how to write UPDATE statement? Think again.</title><link>http://msmvps.com/blogs/omar/archive/2007/01/20/think-you-know-how-to-write-update-statement-think-again.aspx#1695061</link><pubDate>Fri, 12 Jun 2009 01:01:03 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1695061</guid><dc:creator>r kelly sex tape</dc:creator><description>&lt;p&gt;Now inside the r kelly sex tape now &lt;a rel="nofollow" target="_new" href="http://www.youtube.com/user/rkellytapesex"&gt;www.youtube.com/.../rkellytapesex&lt;/a&gt;&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1695061" width="1" height="1"&gt;</description></item><item><title>re: Think you know how to write UPDATE statement? Think again.</title><link>http://msmvps.com/blogs/omar/archive/2007/01/20/think-you-know-how-to-write-update-statement-think-again.aspx#1694977</link><pubDate>Thu, 11 Jun 2009 09:04:20 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1694977</guid><dc:creator>paris hilton sex tape</dc:creator><description>&lt;p&gt;Nice site about watch paris hilton sex tape&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1694977" width="1" height="1"&gt;</description></item><item><title>re: Think you know how to write UPDATE statement? Think again.</title><link>http://msmvps.com/blogs/omar/archive/2007/01/20/think-you-know-how-to-write-update-statement-think-again.aspx#1694952</link><pubDate>Thu, 11 Jun 2009 02:54:10 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1694952</guid><dc:creator>gas powered scooters</dc:creator><description>&lt;p&gt;Help me to find rock gas powered scooters&lt;/p&gt;
&lt;p&gt;&lt;a rel="nofollow" target="_new" href="http://www.world66.com/member/gas_powered_scoote"&gt;www.world66.com/.../gas_powered_scoote&lt;/a&gt;&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1694952" width="1" height="1"&gt;</description></item><item><title>re: Think you know how to write UPDATE statement? Think again.</title><link>http://msmvps.com/blogs/omar/archive/2007/01/20/think-you-know-how-to-write-update-statement-think-again.aspx#1665442</link><pubDate>Sat, 24 Jan 2009 11:32:08 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1665442</guid><dc:creator>chetan</dc:creator><description>&lt;p&gt;i am using &lt;/p&gt;
&lt;p&gt;string sql = &amp;quot;UPDATE Payment_Getway SET paymentstatus = &amp;#39;&amp;quot; + status + &amp;quot;&amp;#39; WHERE CAST([ID] AS VARCHAR(20)) = &amp;#39;&amp;quot; + pgid + &amp;quot;&amp;#39;&amp;quot;;&lt;/p&gt;
&lt;p&gt;Execute_Query(sql);&lt;/p&gt;
&lt;p&gt;update statement is not executed.&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1665442" width="1" height="1"&gt;</description></item><item><title>re: Think you know how to write UPDATE statement? Think again.</title><link>http://msmvps.com/blogs/omar/archive/2007/01/20/think-you-know-how-to-write-update-statement-think-again.aspx#1558998</link><pubDate>Fri, 28 Mar 2008 15:27:10 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1558998</guid><dc:creator>Tahajjud Miah</dc:creator><description>&lt;p&gt;Slms Omar,&lt;/p&gt;
&lt;p&gt;I must say I am impressed with your knowledge! From what I understand, you are advocating updates without references to foreign keys - i assume you would have a separate procedure to deal with such updates because they are called very infrequently and hence can take the hit? &lt;/p&gt;
&lt;p&gt;or are you advocating no keys in the data layer and offloading that to the application layer like some extremely large databases?&lt;/p&gt;
&lt;p&gt;wa&amp;#39;slm,&lt;/p&gt;
&lt;p&gt;T&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1558998" width="1" height="1"&gt;</description></item><item><title>re: Think you know how to write UPDATE statement? Think again.</title><link>http://msmvps.com/blogs/omar/archive/2007/01/20/think-you-know-how-to-write-update-statement-think-again.aspx#1347098</link><pubDate>Thu, 22 Nov 2007 11:31:01 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1347098</guid><dc:creator>Hemant Gupta</dc:creator><description>&lt;p&gt;Hi,&lt;/p&gt;
&lt;p&gt; great article and i would like to say that i am a great fan of your, i have one eye on your blog all the time. regarding the update article i agree with your but can you shed some light how really do we handle a update statement when we are updating a form with 1-20 feilds. cause way i see it doing it with lot of if else will also have its over head. won't it. &amp;nbsp;&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1347098" width="1" height="1"&gt;</description></item><item><title>10 cool web development related articles in 2007 </title><link>http://msmvps.com/blogs/omar/archive/2007/01/20/think-you-know-how-to-write-update-statement-think-again.aspx#1344400</link><pubDate>Wed, 21 Nov 2007 11:04:23 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1344400</guid><dc:creator>杨正祎</dc:creator><description>&lt;p&gt;非原创，来源网络。感谢原作者奉献如此精彩文章。原文地址：&lt;/p&gt;
&lt;p&gt;&lt;a rel="nofollow" target="_new" href="http://www.cnblogs.com/dflying/archive/2007/10/13/922901.html"&gt;www.cnblogs.com/.../922901.html&lt;/a&gt; 10...&lt;/p&gt;
&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1344400" width="1" height="1"&gt;</description></item><item><title>re: Think you know how to write UPDATE statement? Think again.</title><link>http://msmvps.com/blogs/omar/archive/2007/01/20/think-you-know-how-to-write-update-statement-think-again.aspx#1262498</link><pubDate>Wed, 24 Oct 2007 23:56:52 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1262498</guid><dc:creator>ford1123,ford12331</dc:creator><description>&lt;p&gt;All about ford cars and parts &amp;lt;a href=&amp;quot; &lt;a rel="nofollow" target="_new" href="http://ford-seattle.uertr.com"&gt;http://ford-seattle.uertr.com&lt;/a&gt; &amp;quot;&amp;gt;albany ford new york&amp;lt;/a&amp;gt;albany ford new york&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1262498" width="1" height="1"&gt;</description></item><item><title>re: Think you know how to write UPDATE statement? Think again.</title><link>http://msmvps.com/blogs/omar/archive/2007/01/20/think-you-know-how-to-write-update-statement-think-again.aspx#1244171</link><pubDate>Fri, 12 Oct 2007 08:25:46 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1244171</guid><dc:creator>lazynerd</dc:creator><description>&lt;p&gt;Omar, way to go... wish I could be ever like you. At least will try to make my son like you. Thats what I can say.&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1244171" width="1" height="1"&gt;</description></item><item><title>re: Think you know how to write UPDATE statement? Think again.</title><link>http://msmvps.com/blogs/omar/archive/2007/01/20/think-you-know-how-to-write-update-statement-think-again.aspx#1225729</link><pubDate>Tue, 02 Oct 2007 17:47:05 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1225729</guid><dc:creator>caveman_dick</dc:creator><description>&lt;p&gt;This is where decent a decent OR mapper like llblgen pro will be your best friend, it dynamically creates update statements based on the fields you actually change!&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1225729" width="1" height="1"&gt;</description></item><item><title>re: Think you know how to write UPDATE statement? Think again.</title><link>http://msmvps.com/blogs/omar/archive/2007/01/20/think-you-know-how-to-write-update-statement-think-again.aspx#1148571</link><pubDate>Thu, 30 Aug 2007 12:00:30 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1148571</guid><dc:creator>AllForYou123,AllForYou123</dc:creator><description>&lt;p&gt;Helo, it is very interesting site. If You want you can visit mine. &amp;lt;a href=&amp;quot; &lt;a rel="nofollow" target="_new" href="http://mail-rcn-web.usgol.info/"&gt;mail-rcn-web.usgol.info&lt;/a&gt; &amp;quot;&amp;gt; sook yin lee&amp;lt;/a&amp;gt; I have make it myself. There you can find all about &amp;nbsp;sook yin lee etc...&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1148571" width="1" height="1"&gt;</description></item><item><title>re: Think you know how to write UPDATE statement? Think again.</title><link>http://msmvps.com/blogs/omar/archive/2007/01/20/think-you-know-how-to-write-update-statement-think-again.aspx#1139780</link><pubDate>Mon, 27 Aug 2007 01:46:37 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1139780</guid><dc:creator>AirfareForYou,AirfareForYou</dc:creator><description>&lt;p&gt;Helo, it is very interesting site. If You want you can visit mine. &amp;lt;a href=&amp;quot; &lt;a rel="nofollow" target="_new" href="http://hawaii-airline.usaspace.biz/"&gt;hawaii-airline.usaspace.biz&lt;/a&gt; &amp;quot;&amp;gt; ted buy airline&amp;lt;/a&amp;gt; I have make it myself. There you can find all about airlines, cheap airfares etc...&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1139780" width="1" height="1"&gt;</description></item><item><title>re: Think you know how to write UPDATE statement? Think again.</title><link>http://msmvps.com/blogs/omar/archive/2007/01/20/think-you-know-how-to-write-update-statement-think-again.aspx#1139779</link><pubDate>Mon, 27 Aug 2007 01:45:58 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1139779</guid><dc:creator>AirfareForYou,AirfareForYou</dc:creator><description>&lt;p&gt;Helo, it is very interesting site. If You want you can visit mine. &amp;lt;a href=&amp;quot; &lt;a rel="nofollow" target="_new" href="http://hawaii-airline.usaspace.biz/"&gt;hawaii-airline.usaspace.biz&lt;/a&gt; &amp;quot;&amp;gt; ted buy airline&amp;lt;/a&amp;gt; I have make it myself. There you can find all about airlines, cheap airfares etc...&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1139779" width="1" height="1"&gt;</description></item><item><title>re: Think you know how to write UPDATE statement? Think again.</title><link>http://msmvps.com/blogs/omar/archive/2007/01/20/think-you-know-how-to-write-update-statement-think-again.aspx#1134227</link><pubDate>Fri, 24 Aug 2007 01:18:58 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1134227</guid><dc:creator>LawyerForYou,LawyerForYou</dc:creator><description>&lt;p&gt;Helo, it is very interesting site. If You want you can visit mine. &amp;lt;a href=&amp;quot; &lt;a rel="nofollow" target="_new" href="http://wv-regional-jail.hostsy.us/"&gt;wv-regional-jail.hostsy.us&lt;/a&gt; &amp;quot;&amp;gt; murphys law law&amp;lt;/a&amp;gt; I have make it myself. There you can find all about law, lawyers, judges etc...&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1134227" width="1" height="1"&gt;</description></item><item><title>re: Think you know how to write UPDATE statement? Think again.</title><link>http://msmvps.com/blogs/omar/archive/2007/01/20/think-you-know-how-to-write-update-statement-think-again.aspx#1134226</link><pubDate>Fri, 24 Aug 2007 01:18:55 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1134226</guid><dc:creator>LawyerForYou,LawyerForYou</dc:creator><description>&lt;p&gt;Helo, it is very interesting site. If You want you can visit mine. &amp;lt;a href=&amp;quot; &lt;a rel="nofollow" target="_new" href="http://wv-regional-jail.hostsy.us/"&gt;wv-regional-jail.hostsy.us&lt;/a&gt; &amp;quot;&amp;gt; murphys law law&amp;lt;/a&amp;gt; I have make it myself. There you can find all about law, lawyers, judges etc...&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1134226" width="1" height="1"&gt;</description></item><item><title>re: Think you know how to write UPDATE statement? Think again.</title><link>http://msmvps.com/blogs/omar/archive/2007/01/20/think-you-know-how-to-write-update-statement-think-again.aspx#1125929</link><pubDate>Mon, 20 Aug 2007 11:00:34 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1125929</guid><dc:creator>DietMan1,Diet</dc:creator><description>&lt;p&gt;Helo, it is very interesting site. If You want you can visit mine. &amp;lt;a href=&amp;quot; &lt;a rel="nofollow" target="_new" href="http://atken-diet.simplediet.org/"&gt;atken-diet.simplediet.org&lt;/a&gt; &amp;quot;&amp;gt; low weight loss chloresterol diet&amp;lt;/a&amp;gt; I have make it myself. There you can find all about healthy food.&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1125929" width="1" height="1"&gt;</description></item><item><title>re: Think you know how to write UPDATE statement? Think again.</title><link>http://msmvps.com/blogs/omar/archive/2007/01/20/think-you-know-how-to-write-update-statement-think-again.aspx#1121866</link><pubDate>Sat, 18 Aug 2007 18:03:20 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1121866</guid><dc:creator>Anabolik forever,Anabolikoid</dc:creator><description>&lt;p&gt;Hi good for you but visit this &amp;lt;a href=&amp;quot; &lt;a rel="nofollow" target="_new" href="http://proviron.tabletdiet.org/"&gt;proviron.tabletdiet.org&lt;/a&gt; &amp;quot;&amp;gt;buy online ephedrine product&amp;lt;/a&amp;gt;&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1121866" width="1" height="1"&gt;</description></item><item><title>re: Think you know how to write UPDATE statement? Think again.</title><link>http://msmvps.com/blogs/omar/archive/2007/01/20/think-you-know-how-to-write-update-statement-think-again.aspx#931737</link><pubDate>Tue, 29 May 2007 08:24:31 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:931737</guid><dc:creator>Moshiur Murshed</dc:creator><description>&lt;p&gt;Interesting.... &lt;/p&gt;
&lt;p&gt;My Idea was to introduce more Foreign keys in a table so that I can enforce referantial intigrity...&lt;/p&gt;
&lt;p&gt;I have to think again......&lt;/p&gt;
&lt;p&gt;Thanx for sharing.&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=931737" width="1" height="1"&gt;</description></item><item><title>re: Think you know how to write UPDATE statement? Think again.</title><link>http://msmvps.com/blogs/omar/archive/2007/01/20/think-you-know-how-to-write-update-statement-think-again.aspx#910181</link><pubDate>Thu, 17 May 2007 23:42:57 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:910181</guid><dc:creator>ewa sonnet</dc:creator><description>&lt;p&gt;I'm no good my love and have fun with I'm no good who else love extention green world Thanks you Buy &lt;a rel="nofollow" target="_new" href="http://zej.bravehost.com/ewa-sonnet.html"&gt;zej.bravehost.com/ewa-sonnet.html&lt;/a&gt; super children Glad to see you time I'm no good Buy Order this come to you who else Good work! ewa sonnet &lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=910181" width="1" height="1"&gt;</description></item></channel></rss>