SQL脚本
朋友传给我的文件 我在查询分析器里面执行 显示有错误 代码如下:
CREATE DATABASE [db_GoodsManage] ON PRIMARY
( NAME = N'db_GoodsManage', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\db_GoodsManage.mdf' , SIZE = 2240KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'db_GoodsManage_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\db_GoodsManage_log.LDF' , SIZE = 560KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
COLLATE Chinese_PRC_CI_AS
GO
EXEC dbo.sp_dbcmptlevel @dbname=N'db_GoodsManage', @new_cmptlevel=90
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [db_GoodsManage].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [db_GoodsManage] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [db_GoodsManage] SET ANSI_NULLS OFF
GO
ALTER DATABASE [db_GoodsManage] SET ANSI_PADDING OFF
GO
ALTER DATABASE [db_GoodsManage] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [db_GoodsManage] SET ARITHABORT OFF
GO
ALTER DATABASE [db_GoodsManage] SET AUTO_CLOSE ON
GO
ALTER DATABASE [db_GoodsManage] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [db_GoodsManage] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [db_GoodsMan
相关问答:
执行的顺序:
1)文件浏览框(选择文件使用)
选择好文件后
点击一个导入按钮的时候 ,把上面上传框里的csv文件以一个ID为文件名,上传到**/**文件夹下
2)读取这个文件夹下的csv的文件,转换成sql
3 ......
环境:1.win2003server+oracle9i
2.oracle9i字符集为AMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer版本 1.5.5
现象描述: 1.在sql developer 中查询oracle中的某个表,中文全部显示为乱码。
......
sql可以有两个以上的触发器吗??我指的是for触发器,那其他的呢??
什么意思?
可以的
10个都没问题
可是我写了两个for insert 触发器,造成进程阻塞了呢?怎么办呢?请高人指点
......
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
table1:
uID uName
1 小李
2 小张
table2:
pID uID type
1 1 H1
2   ......