2011年11月7日

treecode table
摘要： USE [DNF_09] GO/****** Object: Table [dbo].[Dnft_tra_TreeCode] Script Date: 11/07/2011 16:40:18 ******/ SET ANSI_NULLS ON GOSET QUOTED_IDENTIFIER ON GOSET ANSI_PADDING ON GOCREATE TABLE [dbo].[Dnft_tra_TreeCode]( [key_seq] [varchar](50) NOT NULL, [link_key_seq] [varchar](50) NULL, [Tree_Name] [nvarc 阅读全文
posted @ 2011-11-07 16:41 iSun自由软件团件 阅读(270) 评论(0) 推荐(0)
 
gettree
摘要： USE [DNF_09] GO /****** Object: UserDefinedFunction [dbo].[Dnff_sys_GetTree] Script Date: 11/07/2011 16:34:10 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER ON GO-- Drop FUNCTION Dnff_sys_GetTree ALTER FUNCTION [dbo].[Dnff_sys_GetTree]( /* delete Dnft_tra_TreeCode insert Dnft_tra_TreeCode(key.. 阅读全文
posted @ 2011-11-07 16:40 iSun自由软件团件 阅读(185) 评论(0) 推荐(0)
 
treecode
摘要： USE [DNF_09] GO /****** Object: UserDefinedFunction [dbo].[Dnff_sys_GetTree] Script Date: 11/07/2011 16:34:10 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER ON GO-- Drop FUNCTION Dnff_sys_GetTree ALTER FUNCTION [dbo].[Dnff_sys_GetTree]( /* delete Dnft_tra_TreeCode insert Dnft_tra_TreeCode(key.. 阅读全文
posted @ 2011-11-07 16:38 iSun自由软件团件 阅读(215) 评论(0) 推荐(0)
 
test
摘要： USE [DNF_09] GO/****** Object: DdlTrigger [tri_DDL_DATABASE_LEVEL_EVENTS] Script Date: 11/01/2011 10:17:04 ******/ SET ANSI_NULLS ON GOSET QUOTED_IDENTIFIER ON GO--建立触发器 CREATE TRIGGER [tri_DDL_DATABASE_LEVEL_EVENTS] ON DATABASE FOR DDL_DATABASE_LEVEL_EVENTS AS DECLARE @data XML SET @data = EVENTDA. 阅读全文
posted @ 2011-11-07 10:00 iSun自由软件团件 阅读(220) 评论(0) 推荐(0)
 
通用存储
摘要： USE [DNF_09] GO/****** Object: DdlTrigger [tri_DDL_DATABASE_LEVEL_EVENTS] Script Date: 11/01/2011 10:17:04 ******/ SET ANSI_NULLS ON GOSET QUOTED_IDENTIFIER ON GO--建立触发器 CREATE TRIGGER [tri_DDL_DATABASE_LEVEL_EVENTS] ON DATABASE FOR DDL_DATABASE_LEVEL_EVENTS AS DECLARE @data XML SET @data = EVENTDA. 阅读全文
posted @ 2011-11-07 09:12 iSun自由软件团件 阅读(119) 评论(0) 推荐(0)