Delete record in sqlce

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Any one know how to delete the first or the second record using SQL statement.


Thx,
wyghf
 
"First or second" based on what criteria?? Pass in whatever criteria you
want and execute the delete.

DELETE FROM Job WHERE ID = YourSelectedID
 
I have A and B table in sqlce database,A is master,B is detail.
The customer require when the record count in A is greater than 20,we must
delete
the first record and append new record,just like a queue.How to achieve it?


Thx,
wyghf
 
Thanks.I've solved this problem

Earl said:
"First or second" based on what criteria?? Pass in whatever criteria you
want and execute the delete.

DELETE FROM Job WHERE ID = YourSelectedID
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ActiveSync in Wince 2
Create nonresize and nonmovable window 3
Slow loading of sqlce database from sqlserver 1
Create Form in advance 8
SQLCE 3.5 and Management Studio 2005 9
Help about choosing efficient database technology 3
SQLCE in C# 8
SqlCe Insert Record Performance 16

Back
Top