Re: thinking about UPDATE

• 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 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=