INSERT INTO CommentTable (Date, Site, Comments, Total)SELECt '2010-04-01 00:00:00.000', Site, 0, 0FROM SiteTableWHERe Site NOT IN (SELECt DISTINCT Site FROM CommmentTable WHERe [Date] = DATEADD(mm, DATEDIFF(mm, 0, GetDate()) -1,0))
INSERT INTO CommentTable (Date, Site, Comments, Total)SELECt '2010-04-01 00:00:00.000', Site, 0, 0FROM SiteTableWHERe Site NOT IN (SELECt DISTINCT Site FROM CommmentTable WHERe [Date] = DATEADD(mm, DATEDIFF(mm, 0, GetDate()) -1,0))
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
