USE [master]
GO
/****** Object: Database [Woodgrove] Script Date: 11/29/2006 23:38:40 ******/
CREATE DATABASE [Woodgrove] ON PRIMARY
( NAME = N'Woodgrove', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Woodgrove.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'Woodgrove_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Woodgrove_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
COLLATE SQL_Latin1_General_CP1_CI_AS
GO
EXEC dbo.sp_dbcmptlevel @dbname=N'Woodgrove', @new_cmptlevel=90
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [Woodgrove].[dbo].[sp_fulltext_database] @action = 'disable'
end
GO
ALTER DATABASE [Woodgrove] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [Woodgrove] SET ANSI_NULLS OFF
GO
ALTER DATABASE [Woodgrove] SET ANSI_PADDING OFF
GO
ALTER DATABASE [Woodgrove] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [Woodgrove] SET ARITHABORT OFF
GO
ALTER DATABASE [Woodgrove] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [Woodgrove] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [Woodgrove] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [Woodgrove] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [Woodgrove] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [Woodgrove] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [Woodgrove] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [Woodgrove] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [Woodgrove] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [Woodgrove] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [Woodgrove] SET ENABLE_BROKER
GO
ALTER DATABASE [Woodgrove] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [Woodgrove] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [Woodgrove] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [Woodgrove] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [Woodgrove] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [Woodgrove] SET READ_WRITE
GO
ALTER DATABASE [Woodgrove] SET RECOVERY FULL
GO
ALTER DATABASE [Woodgrove] SET MULTI_USER
GO
ALTER DATABASE [Woodgrove] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [Woodgrove] SET DB_CHAINING OFF
USE [Woodgrove]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AccountInfo]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[AccountInfo](
[AccountNo] [int] NOT NULL,
[PIN] [smallint] NOT NULL,
CONSTRAINT [PK_AccountInfo] PRIMARY KEY CLUSTERED
(
[AccountNo] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AccountBalance]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[AccountBalance](
[AccountNo] [int] NOT NULL,
[Balance] [money] NOT NULL,
CONSTRAINT [PK_AccountBalance] PRIMARY KEY CLUSTERED
(
[AccountNo] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
USE [Woodgrove]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CheckPIN]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[CheckPIN]
@AccountNo int,
@ThrowError smallint,
@TestPIN smallint,
@Valid smallint output
AS
begin
-- Set transactional isolation level
set transaction isolation level read committed
-- Don''t return record count
set nocount on
-- Throw an error if requested
if (@ThrowError > 0)
begin
raiserror(''Error requested to be thrown.'',16,-1,''CheckPIN'')
return -1
end
-- Assume failure
SET @Valid = 0
-- Pull PIN
DECLARE @PIN smallint
SET @PIN = (SELECT [PIN]
FROM [dbo].[AccountInfo]
WHERE [AccountNo] = @AccountNo)
-- Check for error
if (@PIN IS NULL)
begin
raiserror(''There is no such ac�
WWF step by step 源码 （1386个子文件） 
Global.asax 2KB Global.asax 2KB QuoteService.asmx 94B QuoteService.asmx 94B QuoteService.asmx 59B
USMap.bmp 530KB USMap.bmp 530KB Tank.bmp 34KB Tank.bmp 34KB Bottle4.bmp 15KB Bottle5.bmp 15KB Bottle2.bmp 15KB Bottle1.bmp 15KB Bottle3.bmp 15KB Bottle4.bmp 15KB Bottle5.bmp 15KB Bottle2.bmp 15KB Bottle1.bmp 15KB Bottle3.bmp 15KB TruckWB.bmp 2KB TruckEB.bmp 2KB TruckWB.bmp 2KB TruckEB.bmp 2KB Eight.bmp 1KB Zero.bmp 1KB Four.bmp 1KB Nine.bmp 1KB Five.bmp 1KB Seven.bmp 1KB Dollar.bmp 1KB Six.bmp 1KB Two.bmp 1KB Three.bmp 1KB One.bmp 1KB Eight.bmp 1KB Zero.bmp 1KB Four.bmp 1KB Nine.bmp 1KB Five.bmp 1KB Seven.bmp 1KB Dollar.bmp 1KB Six.bmp 1KB Two.bmp 1KB Three.bmp 1KB One.bmp 1KB Decimal.bmp 882B Decimal.bmp 882B FtpImage.bmp 774B FtpImage.bmp 774B Web.config 4KB app.config 2KB app.config 2KB eBroker.exe.config 2KB eBroker.vshost.exe.config 2KB app.config 1KB Questioner.vshost.exe.config 1KB Questioner.exe.config 1KB app.config 1KB Questioner.vshost.exe.config 1KB Questioner.exe.config 1KB app.config 1KB app.config 1KB app.config 1KB app.config 1KB Questioner.vshost.exe.config 1KB Questioner.exe.config 1KB app.config 925B QuoteGenerator.vshost.exe.config 925B QuoteGenerator.exe.config 925B app.config 871B WorkflowATM.vshost.exe.config 669B App.config 401B WorkflowATM.exe.config 401B App.config 401B WorkflowPersister.vshost.exe.config 399B WorkflowPersister.exe.config 399B WorkflowIdler.vshost.exe.config 399B WorkflowIdler.exe.config 399B App.config 267B WorkflowTracker.exe.config 267B WorkflowTracker.vshost.exe.config 267B App.config 267B App.config 267B WorkflowTracker.exe.config 267B WorkflowTracker.vshost.exe.config 267B App.config 267B WorkflowTracker.exe.config 267B WorkflowTracker.vshost.exe.config 267B App.config 267B App.config 263B App.config 263B App.config 263B App.config 262B Workflow1.designer.cs 60KB Workflow1.designer.cs 57KB Workflow1.cs 25KB Workflow1.cs 21KB Form1.cs 21KB Form1.cs 21KB Form1.Designer.cs 20KB共 1386 条
- 1
- 2
- 3
- 4
- 5
- 6
- 14
资源评论
yqgood
- 粉丝: 0
- 资源: 3
最新资源
- Springboot + mybatis-plus + layui 实现的博客系统源代码全套技术资料.zip
- 基于SpringBoot的毕业设计选题系统源代码项目包含全套技术资料.zip
- GGJGJGJGGDGGDGG
- 基于JSP+Servlet的网上书店系统源代码项目包含全套技术资料.zip
- BlurAdmin 是一款使用 AngularJs + Bootstrap实现的单页管理端模版，视觉冲击极强的管理后台，各种动画效果
- 各种排序算法 Python 实现的源代码
- 自动化应用驱动的容器弹性管理平台解决方案
- 基于springboot+element的校园服务平台源代码项目包含全套技术资料.zip
- 金山PDF教育版编辑器
- 各种排序算法java实现的源代码.zip
- 毕业设计- 基于溯源图的APT攻击检测方法优化文档+源码+全部资料+高分项目.zip
- 基于 Kotlin 和 Quarkus 的后台管理系统脚手架，文档+源码+全部资料+高分项目.zip
- 本科毕设-基于超级账本fabric的茶叶溯源系统文档+源码+全部资料+高分项目.zip
- 基于 Vue 2 + Uni-app + Spring Boot 2 的农产品溯源系统，实现了农场管理、农产品 管理、农产品溯源管理、⽤⼾扫码溯源等功能。文档+源码+全部资料+高分项目.zip
- 基于Fabric超级账本为底层的企业资产管理、交易、防伪、溯源一体化的开源区块链解决方案文档+源码+全部资料+高分项目.zip
- 基于babylonjs和这个库，你可以进行联机调试材质，并提供光源调试，版本回溯，版本保存，材质库，聊天室等一系列功能文档+源码+全部资料+高分项目.zip
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
