Re: thinking about UPDATE
From: x <x-false_at_yahoo.com>
Date: Wed, 21 Jul 2004 13:33:16 +0300
Message-ID: <40fe466e$1_at_post.usenet.com>
Date: Wed, 21 Jul 2004 13:33:16 +0300
Message-ID: <40fe466e$1_at_post.usenet.com>
- Post for FREE via your newsreader at post.usenet.com ****
"Marshall Spight" <mspight_at_dnai.com> wrote in message news:N0mLc.114236$WX.22912_at_attbi_s51...
> But what the heck is UPDATE?
Try this with your SQL DBMS:
- define a table T with a primary key F of type integer - insert several records with consecutive values for F (like 1,2,3,...) - try UPDATE T SET F=F+1 and see what happen
MS ACCESS 2002 and Visual FoxPro 8.0 give a key violation error. SQL Server 2000 execute the update without complaining.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
- Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=