[dba-SQLServer] Delete

Doug Murphy dw-murphy at cox.net
Mon Aug 8 11:02:41 CDT 2011

Don't know. I am more of an empirical developer. I'd try it.

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Wil Wakely
Sent: Sunday, August 07, 2011 8:06 PM
To: sql-dba
Subject: [dba-SQLServer] Delete

Is this a correct sql statement to delete the first 5 rows (oldest dates) of
a recordset for Access 2002? I'm new to SQL.

strSQL1 = "DELETE FROM rs WHERE TOP 5,  player=1 ORDER BY playdate ASC;"
DoCmd.RunSQL strSQL1


===wil wakely
sunny san diego ca
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com

More information about the dba-SQLServer mailing list