Welcome to dbForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

filter for SQL commad ?

 
   Database Forums (Home) -> Client RSS
Next:  I don't know filter to SQL command  
Author Message
Joseph




Joined: Sep 29, 2005
Posts: 3



(Msg. 1) Posted: Thu Sep 29, 2005 12:30 pm
Post subject: filter for SQL commad ?

I don't know to write SQL command filter.
m_strQueryDelete.Format("DELETE FROM tab WHERE (Col1 = 'abc' AND Col2 = 'abc' AND ?????)"
example: ODBC found 100 records.
I need to delete first 90 records and to leave last 10 records.

Thank you

Joseph

 >> Stay informed about: filter for SQL commad ? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
How can I use MDX functions in SQL Query Analyzer (Client .. - I'm very new to using MS-SQL stuffs and the IT dept here doesn't have any DBMA to speak of. Thus, I'm a bit on my own - except for you helpful people... I just installed the Client Tools on my workstation and tried a simple query: SELECT IIf(TBL.fl...

problem deploying access project - I have given a copy of my access project to user. This was developed in Access 2003 in Access 2000 file format. User PC is running Access 2000 ( 904402 SR-1). The problem seems to be that Functions are not visible to thic client so queries and forms..

Why the table is locked ? - Dear all, I have Access Font End to SQL server Back end. In an Access form, I use combobox, based on a stored procedure, which based on 1 table (SELECT LocationID, LocationDescription FROM Locations). When I open the form and check in the SQL server....

SQL problem pls help - I have installed Visual Studio 2005 beta 2 that include the SQL Express. Then I installed the SQLClient to my pc too. And when I click on the sql group An error message pops up "A connection could not be established to Computername\sqlexpress. ....

enterprise manager error - Hi, When trying to modify or add a table using enterprise manager I got this message error: Enterprise manager: not enough storage is available to complete this operation. I have a lot off space available. I don't have a memory leake. My server is..
   Database Forums (Home) -> Client All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]