- 博客(8)
- 收藏
- 关注
RSS订阅转载 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
280
原创 sql default
--alter table [dbo].[BUDDY_CustomerCardInfo] --drop constraint [DF_BUDDY_CustomerCardInfo_LogDate]ALTER TABLE [dbo].[BUDDY_CustomerCardInfo] ADD CONSTRAINT [DF_BUDDY_CustomerCar
2009-12-13 01:01:00
365
1
原创 proposal presentation
前天去客户那里展示proposal，比较郁闷，总结如下:1、与会的不仅包括客户IT人员，多位业务人员也到会2、IT人员明显弱势，在业务人员面前没有话语权3、业务人员不懂也不关心技术，她们只关心业务4、proposal中对业务部分只有一页，没有深入展示，特别是核心业务流程部分没有画出。而且对业务的理解不够到位5、业务人员要求展示在此类项目上的经验，这个没有准备（case stud
2009-10-24 15:33:00
560
原创 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
473
原创 SQL - DATEADD
select CONVERT(NVARCHAR(8), DATEADD(week, DATEDIFF(week, , GETDATE()), ), 112) select CONVERT(NVARCHAR(8), DATEADD(week, DATEDIFF(week, , GETDATE()), -7), 112) select CONVERT(NVARCHAR(8), DATEAD
2009-07-27 13:19:00
299
原创 Architecture & Design
Architecture: where non-functional decisions are cast and functional requirements are partitioned;Design: where functional requirements are accomplished.
2009-07-27 12:09:00
259
原创 MDX FILTER
select {[Measures].[SF],[Measures].[GAP of SF-ALLOC]} on columns, FILTER([SF_ITEM].[SF PRODUCT LINE].[SF ITEM].MEMBERS, [Measures].[GAP of SF-ALLOC]FROM FORECAST
2009-07-22 13:22:00
849
原创 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
289
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人