USE[master] GO /**//****** Object: Database [UTDB] Script Date: 12/30/2006 09:39:30 ******/ CREATEDATABASE[UTDB]ONPRIMARY ( NAME = N'UTDB', FILENAME = N'UTDB.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOGON ( NAME = N'UTDB_log', FILENAME = N'UTDB_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH =10%) COLLATE Chinese_PRC_CI_AS GO EXEC dbo.sp_dbcmptlevel @dbname=N'UTDB', @new_cmptlevel=90 GO IF (1=FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC[UTDB].[dbo].[sp_fulltext_database]@action='disable' end GO ALTERDATABASE[UTDB]SET ANSI_NULL_DEFAULT OFF GO ALTERDATABASE[UTDB]SET ANSI_NULLS OFF GO ALTERDATABASE[UTDB]SET ANSI_PADDING OFF GO ALTERDATABASE[UTDB]SET ANSI_WARNINGS OFF GO ALTERDATABASE[UTDB]SET ARITHABORT OFF GO ALTERDATABASE[UTDB]SET AUTO_CLOSE OFF GO ALTERDATABASE[UTDB]SET AUTO_CREATE_STATISTICS ON GO ALTERDATABASE[UTDB]SET AUTO_SHRINK OFF GO ALTERDATABASE[UTDB]SET AUTO_UPDATE_STATISTICS ON GO ALTERDATABASE[UTDB]SET CURSOR_CLOSE_ON_COMMIT OFF GO ALTERDATABASE[UTDB]SET CURSOR_DEFAULT GLOBAL GO ALTERDATABASE[UTDB]SET CONCAT_NULL_YIELDS_NULL OFF GO ALTERDATABASE[UTDB]SET NUMERIC_ROUNDABORT OFF GO ALTERDATABASE[UTDB]SET QUOTED_IDENTIFIER OFF GO ALTERDATABASE[UTDB]SET RECURSIVE_TRIGGERS OFF GO ALTERDATABASE[UTDB]SET ENABLE_BROKER GO ALTERDATABASE[UTDB]SET AUTO_UPDATE_STATISTICS_ASYNC OFF GO ALTERDATABASE[UTDB]SET DATE_CORRELATION_OPTIMIZATION OFF GO ALTERDATABASE[UTDB]SET TRUSTWORTHY OFF GO ALTERDATABASE[UTDB]SET ALLOW_SNAPSHOT_ISOLATION OFF GO ALTERDATABASE[UTDB]SET PARAMETERIZATION SIMPLE GO ALTERDATABASE[UTDB]SET READ_WRITE GO ALTERDATABASE[UTDB]SET RECOVERY SIMPLE GO ALTERDATABASE[UTDB]SET MULTI_USER GO ALTERDATABASE[UTDB]SET PAGE_VERIFY CHECKSUM GO ALTERDATABASE[UTDB]SET DB_CHAINING OFF USE[UTDB] GO /**//****** Object: Table [dbo].[BITS_Job] Script Date: 12/30/2006 09:42:09 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATETABLE[dbo].[BITS_Job]( [jobGUID][uniqueidentifier]NOTNULL, [name][nvarchar](256) COLLATE Chinese_PRC_CI_AS NOTNULL, [progress][int]NULL, [action][int]NOTNULLCONSTRAINT[DF_BITS_Job_open]DEFAULT ((1)), CONSTRAINT[PK_BITSJob]PRIMARYKEYCLUSTERED ( [jobGUID]ASC )WITH (PAD_INDEX =OFF, IGNORE_DUP_KEY =OFF) ON[PRIMARY] ) ON[PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Job 的显示名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BITS_Job', @level2type=N'COLUMN',@level2name=N'name' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'决定数据下载完成后执行什么动作:0,不管; 1,打开文件; 2,执行文件;' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BITS_Job', @level2type=N'COLUMN',@level2name=N'action' USE[UTDB] GO /**//****** Object: StoredProcedure [dbo].[BITS_GetJobAction] Script Date: 12/30/2006 09:52:26 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: lava_sdb,,BITS_GetJobAction -- Create date: 12/30/2006 -- Description: -- ============================================= CREATEPROCEDURE[dbo].[BITS_GetJobAction] @jobGuiduniqueidentifier, @actionint OUTPUT AS BEGIN --DECLARE @action int --SELECT @action=0 -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here SELECT@action=[action] FROM dbo.BITS_Job WHERE jobGUID =@jobGuid return@action END /**//****** 插入事例数据 ***********/ INSERTINTO[dbo].[BITS_Job] ([jobGUID],[name],[progress],[action]) VALUES(newID(),'Test1',0,0 ) INSERTINTO[dbo].[BITS_Job] ([jobGUID],[name],[progress],[action]) VALUES(newID(),'Test2',0,0 ) INSERTINTO[dbo].[BITS_Job] ([jobGUID],[name],[progress],[action]) VALUES(newID(),'Test3',0,0 ) INSERTINTO[dbo].[BITS_Job] ([jobGUID],[name],[progress],[action]) VALUES(newID(),'Test4',0,0 )