close

挑選一段時間範圍內的資料

SELECT [Id]
       ,[CameraId]
       ,[CreateDate]
       ,[CarId]
       ,[Type]
       ,[IP]
       ,[Src]
   FROM [CarServer].[dbo].[Photo] WHERE [CreateDate] BETWEEN '20170101 00:00:00.000' AND
                           '20180301 23:59:59.999'


刪除一段時間範圍內的資料


DELETE FROM [CarServer].[dbo].[Photo] WHERE [CreateDate] BETWEEN '20180501 00:00:00.000' AND
                           '20180801 23:59:59.999'

arrow
arrow
    全站熱搜

    me1237guy 發表在 痞客邦 留言(0) 人氣()