![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
database
hgxl
这个作者很懒,什么都没留下…
展开
-
交叉报表
if exists (select * from dbo.sysobjects where id = object_id(N[dbo].[tabone]) and OBJECTPROPERTY(id, NIsUserTable) = 1)drop table [dbo].[tabone]GOCREATE TABLE [dbo].[tabone] ( [id] [int] IDENTIT原创 2005-01-24 09:43:00 · 597 阅读 · 0 评论 -
批量更新插入
insert into dbo.tab(RR_ID, RR_SELECT_ID)SELECT RR_ID, RR_SELECT_ID, FROM dbo.tabETEMP where not exists (select distinct RR_ID from dbo.tab where dbo.tab.RR_ID=dbo.tabETEMP .RR_ID)update dbo.tab原创 2005-01-24 10:00:00 · 521 阅读 · 0 评论