![](https://img-blog.csdnimg.cn/20201014180756913.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Database
fanzhuli
这个作者很懒,什么都没留下…
展开
-
MDX - Accumulation
Sum (PeriodsToDate ([SF INV DATE].[SF INV DATE].[(ALL)],[SF INV DATE].[SF INV DATE].CURRENTMEMBER ),[Measures].[SF_ALLOC_GAP])原创 2009-07-28 17:12:00 · 439 阅读 · 0 评论 -
UPDATE FROM SELECT.txt
UPDATE dbo.FC_CUSTOMER SET SECTION_CODE= A.SECTION_CODEFROM FC_CUSTOMER CLEFT JOIN(SELECT CUSTOMER_CODE,SECT.SECTION_CODE FROM dbo.FC_CUSTOMER CUSTJOIN FC_SALESMAN SL ON SL.SALESMAN_CODE=CUST.SALESMA原创 2009-05-27 13:44:00 · 275 阅读 · 0 评论 -
fetch record count of all tables
<br /><br />set nocount on<br />if object_id(N'tempdb.db.#temp') is not null<br /> drop table #temp<br />create table #temp (name sysname,count numeric(18))<br />insert into #temp<br />select o.name,i.rows<br />from sysobjects o,sysindexes i <br />where转载 2011-03-19 00:15:00 · 265 阅读 · 0 评论