摘要：
http://www.csframework.com/cs-framework-4.0.htm 阅读全文
posted @ 2019-05-31 18:47
zzzp0755
阅读(105)
评论(0)
推荐(0)
摘要：
--判断临时表是否存在，存在则删除重建if exists(select 1 from tempdb..sysobjects where id=object_id('tempdb..#tabName') and xtype='u')drop table #tabNamegocreate table # 阅读全文
posted @ 2019-05-31 15:55
zzzp0755
阅读(146)
评论(0)
推荐(0)
摘要：
select a.name as '表名',b.rows as '表数据行数'from sysobjects a inner join sysindexes bon a.id = b.idwhere a.type = 'u'and b.indid in (0,1)--and a.name not l 阅读全文
posted @ 2019-05-31 15:55
zzzp0755
阅读(182)
评论(0)
推荐(0)
浙公网安备 33010602011771号