什么叫存储的思路?删除: sql server: cn.execute "delete from logrecords where date between '" & format(datStart, "yyyy-mm-dd") & "' and '" & format(datEnd, "yyyy-mm-dd") & "'"access: cn.execute "delete from logrecords where date between #" & format(datStart, "yyyy-mm-dd") & "# and #" & format(datEnd, "yyyy-mm-dd") & "#"
sql server:
cn.execute "delete from logrecords where date between '" & format(datStart, "yyyy-mm-dd") & "' and '" & format(datEnd, "yyyy-mm-dd") & "'"access:
cn.execute "delete from logrecords where date between #" & format(datStart, "yyyy-mm-dd") & "# and #" & format(datEnd, "yyyy-mm-dd") & "#"
列: Log_No Log_start Log_End
值1: 1 20010101 20010101
值2: 2 20010101 20011231
值3: 3 20020101 20021231
表: Log_20011231
(里面是20010101-20011231的日志)表: Log_20021231
(里面是20020101-20021231的日志)表: Log_Current
(里面是20030101-现在的日志)查询时,从Logconfig里取日期值,查相关表。 它通过这样减小表的大小,提高一些检索速度。