2013年10月9日

po_ebps_lifecost

摘要： /****** Object: StoredProcedure [dbo].[po_ebps_lifecost] Script Date: 03/07/2013 11:34:13 ******/SET ANSI_NULLS OFFGOSET QUOTED_IDENTIFIER OFFGO/****** Object: Stored Procedure dbo.po_ebps_lifecost Script Date: 5/18/2004 7:24:48 PM ******//****** Object: Stored Procedure dbo.po_ebps_lifecost Script 阅读全文

posted @ 2013-10-09 17:59 Coyote.#2. 阅读(134) 评论(0) 推荐(0) 编辑

SQL2008 upgrade

摘要： Do NOT USE SQL: =*, *=, TEXT column, Raiserror, BAT: isql Centura: DDE funtion, SqlImmediateAttention SQL: 1. Update, Delete use Table aliases 2. Group by Should add Order by 3. Add ISNULL function for SQL functions. (DATALENGTH, LEFT, LTRIM, REPLICATE, RIGHT, RTRIM, SPACE, SUBSTRING) 4. (Nolock i.. 阅读全文

posted @ 2013-10-09 17:24 Coyote.#2. 阅读(323) 评论(0) 推荐(0) 编辑

导航