jsd117 2010-03-22 15:19
浏览 239
已采纳

SQL语句的转换?

在SQL2000数据库中可以用下面语句创建数据及表,我想在Mysql数据库也用此语句创建,但会出现语法错误。请大家帮一下忙,把改成在MYSQL数据库也能运行的语句,但不能改变其他的(如表的字段等)。只修改语法错误。。。


--1
CREATE DATABASE [FFMS]


--2
USE [FFMS]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[Account]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [dbo].[Account](
 [id] [int] IDENTITY(1,1) NOT NULL,
 [userid] [int] NULL,
 [accountitemid] [int] NULL,
 [amount] [decimal](18, 2) NULL,
 [accountdate] [datetime] NULL,
 [remarks] [varchar](256) NULL,
 CONSTRAINT [PK_Account] PRIMARY KEY CLUSTERED
(
 [id] ASC
) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[User]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [dbo].[User](
 [id] [int] IDENTITY(1,1) NOT NULL,
 [loginname] [varchar](50) NULL,
 [password] [varchar](50) NULL,
 [usernumber] [varchar](50) NULL,
 [name] [varchar](50) NULL,
 CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED
(
 [id] ASC
) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[AccountItem]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [dbo].[AccountItem](
 [id] [int] IDENTITY(1,1) NOT NULL,
 [pid] [int] NULL,
 [accountitemnumber] [varchar](50) NULL,
 [name] [varchar](50) NULL,
 [type] [int] NULL,
 CONSTRAINT [PK_AccountItem] PRIMARY KEY CLUSTERED
(
 [id] ASC
) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[ViewAccount]') AND OBJECTPROPERTY(id, N'IsView') = 1)
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[ViewAccount]
AS
SELECT     dbo.Account.id, dbo.Account.amount, dbo.Account.accountdate, dbo.Account.remarks, dbo.Account.userid, dbo.[User].loginname,
                      dbo.[User].usernumber, dbo.[User].name AS username, dbo.Account.accountitemid, dbo.AccountItem.accountitemnumber,
                      dbo.AccountItem.name AS accountitemname, dbo.AccountItem.type AS accountitemtype, dbo.AccountItem.pid AS asaccountitempid,
                      ParentAccountItem.accountitemnumber AS accountitempnumber, ParentAccountItem.name AS accountitempname
FROM         dbo.Account INNER JOIN
                      dbo.[User] ON dbo.Account.userid = dbo.[User].id INNER JOIN
                      dbo.AccountItem ON dbo.Account.accountitemid = dbo.AccountItem.id INNER JOIN
                      dbo.AccountItem AS ParentAccountItem ON dbo.AccountItem.pid = ParentAccountItem.id
'
GO


INSERT INTO [User] (loginname, password, usernumber, name) VALUES('admin', 'admin', '001', '管理员')

 

 

 

  • 写回答

2条回答 默认 最新

  • bwkbwlbwq 2010-03-22 16:19
    关注

    我建议你去网上搜搜数据库转换工具,Mysql就可以转换成SQL SERVER 和Oracle等等,不过SQL SERVER本身没有。

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
  • ¥15 C#调用python代码(python带有库)
  • ¥15 矩阵加法的规则是两个矩阵中对应位置的数的绝对值进行加和
  • ¥15 活动选择题。最多可以参加几个项目?
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
  • ¥15 vs2019中数据导出问题
  • ¥20 云服务Linux系统TCP-MSS值修改?
  • ¥20 关于#单片机#的问题:项目:使用模拟iic与ov2640通讯环境:F407问题:读取的ID号总是0xff,自己调了调发现在读从机数据时,SDA线上并未有信号变化(语言-c语言)
  • ¥20 怎么在stm32门禁成品上增加查询记录功能
  • ¥15 Source insight编写代码后使用CCS5.2版本import之后,代码跳到注释行里面