![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Mssql
9807146wang
这个作者很懒,什么都没留下…
展开
-
压缩MSSQL日志文件
dump transaction data0505 with no_log go dbcc shrinkdatabase(data0505)原创 2021-06-08 09:21:43 · 117 阅读 · 0 评论 -
要sql語句中加入執行變量
set @sql=Nselect @oogoodscount=SUM(TStoreDecStoreD.fResCount) from TStoreDecStoreD INNER JOIN TStoreDecStoreM ON (TStoreDecStoreD.fStoreDecStoreMID = TStoreDecStoreM.fStoreDecStoreMID) WHERE原创 2008-03-04 14:42:00 · 965 阅读 · 0 评论