Article View: be.comp.programming
Article #2636Re: query
From: Suzan Foster
Date: Sat, 03 Apr 2004 09:37
Date: Sat, 03 Apr 2004 09:37
16 lines
1541 bytes
1541 bytes
Boek Adm Hulp wrote: >>waarde). Ik gebruik volgende query, maar hij geeft een foutmelding: >> >>DELETE FROM tabel WHERE Ander_id=1 LIMIT 1 >> >>hij kankert over die LIMIT 1. Dat is volgens mij toch om te specifieren > > Welke db ? > > bv. mysql kent limit wel, > maar sql server volgens mij niet ?! t-sql kent top die hetzelfde doet. groetjes, su.
Technical Details
Message-ID:
<406e85be$0$564$e4fe514c@news.xs4all.nl>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!newsgate.cistron.nl!transit.news.xs4all.nl!not-for-mailReferences:
<406d7eb8$0$1962$ba620e4c@news.skynet.be> <406e49ab$0$64644$4a441750@news.euronet.nl>Show Full Headers
Complete Article Headers
X-Google-Language: DUTCH,ASCII-7-bit X-Google-Thread: 107324,bb2ad80a5b4cc582 X-Google-Attributes: gid107324,public X-Google-Thread: fcea4,bb2ad80a5b4cc582 X-Google-Attributes: gidfcea4,public X-Google-ArrivalTime: 2004-04-03 01:37:07 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!newsgate.cistron.nl!transit.news.xs4all.nl!not-for-mail Date: Sat, 03 Apr 2004 11:37:05 +0200 From: Suzan Foster <su@islief.nl> User-Agent: Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: be.comp.programming,nl.comp.programmeren Subject: Re: query References: <406d7eb8$0$1962$ba620e4c@news.skynet.be> <406e49ab$0$64644$4a441750@news.euronet.nl> In-Reply-To: <406e49ab$0$64644$4a441750@news.euronet.nl> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Lines: 16 Message-ID: <406e85be$0$564$e4fe514c@news.xs4all.nl> NNTP-Posting-Date: 03 Apr 2004 11:37:02 CEST NNTP-Posting-Host: 217.121.54.248 X-Trace: 1080985022 news.xs4all.nl 564 foz/[::ffff:217.121.54.248]:25600 X-Complaints-To: abuse@xs4all.nl