请教关于MSSQL数据库的动态建立及操作
程序图如下SQL代码:
/****** Object: 建立数据库 Database [DemoTest]******/
CREATE DATABASE [DemoTest] ON PRIMARY
( NAME = N'DemoTest_Data', FILENAME = N'D:\MSSQLDB\DemoTest_Data.mdf' , SIZE = 5120KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
LOG ON
( NAME = N'DemoTest_Log', FILENAME = N'D:\MSSQLDB\DemoTest_Log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 1024KB )
GO
ALTER DATABASE [DemoTest] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [DemoTest].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [DemoTest] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [DemoTest] SET ANSI_NULLS OFF
GO
ALTER DATABASE [DemoTest] SET ANSI_PADDING OFF
GO
ALTER DATABASE [DemoTest] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [DemoTest] SET ARITHABORT OFF
GO
ALTER DATABASE [DemoTest] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [DemoTest] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [DemoTest] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [DemoTest] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [DemoTest] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [DemoTest] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [DemoTest] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [DemoTest] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [DemoTest] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [DemoTest] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [DemoTest] SET DISABLE_BROKER
GO
ALTER DATABASE [DemoTest] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [DemoTest] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [DemoTest] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [DemoTest] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [DemoTest] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [DemoTest] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [DemoTest] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [DemoTest] SET READ_WRITE
GO
ALTER DATABASE [DemoTest] SET RECOVERY FULL
GO
ALTER DATABASE [DemoTest] SET MULTI_USER
GO
ALTER DATABASE [DemoTest] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [DemoTest] SET DB_CHAINING OFF
GO
/******建立表******/
USE [DemoTest]
GO
/****** Object: Table [dbo].[Table_Textstudent]******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Table_Textstudent](
[Text_id] [smallint] IDENTITY(1,1) NOT NULL,
[Text_name] [nvarchar](50) NULL,
[Text_sex] [nvarchar](50) NULL,
[Text_nl] [nvarchar](50) NULL,
[Text_xh] [nvarchar](50) NULL
) ON [PRIMARY]
GO
程序图如下SQL代码:
/****** Object: 建立数据库 Database [DemoTest]******/
CREATE DATABASE [DemoTest] ON PRIMARY
( NAME = N'DemoTest_Data', FILENAME = N'D:\MSSQLDB\DemoTest_Data.mdf' , SIZE = 5120KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
LOG ON
( NAME = N'DemoTest_Log', FILENAME = N'D:\MSSQLDB\DemoTest_Log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 1024KB )
GO
ALTER DATABASE [DemoTest] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [DemoTest].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [DemoTest] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [DemoTest] SET ANSI_NULLS OFF
GO
ALTER DATABASE [DemoTest] SET ANSI_PADDING OFF
GO
ALTER DATABASE [DemoTest] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [DemoTest] SET ARITHABORT OFF
GO
ALTER DATABASE [DemoTest] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [DemoTest] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [DemoTest] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [DemoTest] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [DemoTest] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [DemoTest] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [DemoTest] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [DemoTest] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [DemoTest] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [DemoTest] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [DemoTest] SET DISABLE_BROKER
GO
ALTER DATABASE [DemoTest] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [DemoTest] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [DemoTest] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [DemoTest] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [DemoTest] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [DemoTest] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [DemoTest] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [DemoTest] SET READ_WRITE
GO
ALTER DATABASE [DemoTest] SET RECOVERY FULL
GO
ALTER DATABASE [DemoTest] SET MULTI_USER
GO
ALTER DATABASE [DemoTest] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [DemoTest] SET DB_CHAINING OFF
GO
/******建立表******/
USE [DemoTest]
GO
/****** Object: Table [dbo].[Table_Textstudent]******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Table_Textstudent](
[Text_id] [smallint] IDENTITY(1,1) NOT NULL,
[Text_name] [nvarchar](50) NULL,
[Text_sex] [nvarchar](50) NULL,
[Text_nl] [nvarchar](50) NULL,
[Text_xh] [nvarchar](50) NULL
) ON [PRIMARY]
GO
解决方案 »
- delphi 如何像制定的Http链接提交,并返回数据
- 在线等:请教一个值得出100分的高难度的问题:如何写一个定时程序,没有你想象的那样简单,详情请进......
- 用windowmediaplay控件怎样控制播放的速度??<不是delphi自带的Tmediaplayer控件>
- 用delphi如何在sql数据库表a里的xz字段(binary型)里输入一个rar文件?谢谢!
- 请教,安装VS.NET时的如何进行WINDOWS组件更新?
- 有谁能在windows 2000下有办法把ctrl+alt+del键给屏掉。
- 如何把输入的一个数(整数或实数)转化成大写
- 我的oicq号被盗了!!!!!痛啊^请问怎么取回??有没有这方面有经验的?
- TDecisionGraph的打印问题... 见者给分...
- 如何打开一个已经存在的Excel文件.
- 请问delphi控件的双击事件和拖动事件有冲突怎么办?
- 菜鸟求助,如何在win xp和2000下建立无法关闭的服务
删除数据库
备份数据库
恢复数据库
压缩数据库
备份数据库
恢复数据库
压缩数据库无外乎那几句SQL语句, 还想更全面的话, 可以参考phpMyAdmin
function CREATEDBTAB(DBname,DBtab:string):string;
begin
//代码部分
//测试“数据库”是否存在,不存在,则建立数据库及表
{SQL代码:
/****** Object: 建立数据库 Database [DemoTest]******/
CREATE DATABASE [DemoTest] ON PRIMARY
( NAME = N'DemoTest_Data', FILENAME = N'D:\MSSQLDB\DemoTest_Data.mdf' , SIZE = 5120KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
LOG ON
( NAME = N'DemoTest_Log', FILENAME = N'D:\MSSQLDB\DemoTest_Log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 1024KB )
GO
ALTER DATABASE [DemoTest] SET COMPATIBILITY_LEVEL = 100
GO ..........}end;
就是通过DELPHI+MSSQL综合编程来实现
创建数据库及表》》》》》》》》》
而不是通过所为的SQL角本