使用PD导出sql脚本。
没有设置PD时导出的sql脚本为:
create table dbo.t_call_note (
id int identity(100,1),
caller varchar(32) collate Chinese_PRC_Stroke_90_CS_AS_KS_WS not null,
called varchar(32) collate Chinese_PRC_Stroke_90_CS_AS_KS_WS not null,
ring_time char(19) collate Chinese_PRC_Stroke_90_CS_AS_KS_WS not null,
talk_time char(19) collate Chinese_PRC_Stroke_90_CS_AS_KS_WS null,
end_time char(19) collate Chinese_PRC_Stroke_90_CS_AS_KS_WS null,
user_no varchar(50) collate Chinese_PRC_Stroke_90_CS_AS_KS_WS not null,
user_name varchar(50) collate Chinese_PRC_Stroke_90_CS_AS_KS_WS not null,
talk_long varchar(50) collate Chinese_PRC_Stroke_90_CS_AS_KS_WS null,
call_Id varchar(50) collate Chinese_PRC_Stroke_90_CS_AS_KS_WS not null,
user_pk int collate Chinese_PRC_Stroke_90_CS_AS_KS_WS not null,
create_time char(19) collate Chinese_PRC_Stroke_90_CS_AS_KS_WS not null,
constraint PK_T_CALL_INFO primary key (id)
on "PRIMARY"
)
on "PRIMARY"
go
上面的sql包含collate Chinese_PRC_Stroke_90_CS_AS_KS_WS not null,这是一种排序方式。
但是在执行sql时就会出现错误.如果column为int时就会报错。那么我们如果如下设置,问题不再是问题了!哈哈
1.点击:工具栏-》database-》edit current DBMS
2.选择数据源(以SqlServer2005为例)
Microsoft SQLServer2005\Script\Objects\Column\Add
右边的Values值为:
%20:COLUMN% [%COMPUTE%?AS (%COMPUTE%):[%.L:DATATYPE%=xml?xml[%XMLSchemaCollection%?([%ContentType% ]%XMLSchemaCollection.GeneratedName%): ]:%20:DATATYPE%][.Z:[ collate %ExtCollation%][%ExtRowGuidCol%? RowGuidCol][%IDENTITY%? %IDENTITY%[[(%ExtIdentitySeedInc%)][%ExtIdtNotForReplication%? not for replication]]:[%ExtNullConstName%? constraint %ExtNullConstName%][ %NULL%][ %NOTNULL%]][[%ExtDeftConstName%? constraint %ExtDeftConstName%] default %DEFAULT%]]
[%CONSTDEFN%]]
修改为:
%20:COLUMN% [%COMPUTE%?AS (%COMPUTE%):[%.L:DATATYPE%=xml?xml[%XMLSchemaCollection%?([%ContentType% ]%XMLSchemaCollection.GeneratedName%): ]:%20:DATATYPE%][%ExtRowGuidCol%? RowGuidCol][%IDENTITY%? %IDENTITY%[[(%ExtIdentitySeedInc%)][%ExtIdtNotForReplication%? not for replication]]:[%ExtNullConstName%? constraint %ExtNullConstName%][ %NULL%][ %NOTNULL%]][[%ExtDeftConstName%? constraint %ExtDeftConstName%] default %DEFAULT%]
[%CONSTDEFN%]]
修改的内容就是去掉:[.Z:[ collate %ExtCollation%]以及最后一个"]"
再次导出sql脚本就不会出现collate Chinese_PRC_Stroke_90_CS_AS_KS_WS not null.
如下:
create table dbo.t_call_note (
id int identity(100,1),
caller varchar(32) not null,
called varchar(32) not null,
ring_time char(19) not null,
talk_time char(19) null,
end_time char(19) null,
user_no varchar(50) not null,
user_name varchar(50) not null,
talk_long varchar(50) null,
call_Id varchar(50) not null,
user_pk int not null,
create_time char(19) not null,
constraint PK_T_CALL_INFO primary key (id)
on "PRIMARY"
)
on "PRIMARY"
go
希望能有更好的办法。这只是小弟不才自己找到的解决办法。希望对大家有所帮助
分享到:
相关推荐
这是Power Design,是生成的SQL语句不包含collate Chinese_PRC_CI_AS,可以在SQL Server中直接运行不报错
ALTER COLUMN colname nvarchar(100) COLLATE Chinese_PRC_CI_AS --不区分大小写 ALTER TABLE tb ALTER COLUMN colname nvarchar(100) COLLATE Chinese_PRC_CS_AS --区分大小写 alter database 数据库 COLLATE ...
[Name] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, [SortID] float(53) NULL, [ParentID] float(53) NULL, [Path] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, [Enabled] float(53) NULL, [Jianpin] ...
[CASENO] [varchar](200) COLLATE Chinese_PRC_CI_AS NULL, [MATERIALID] [int] NULL, [MATERIALNAME] [varchar](200) COLLATE Chinese_PRC_CI_AS NULL, [PAGECONTENT] [int] NULL, [FILENO] [int] NOT NULL, ...
COLLATE Chinese_PRC_CI_AS GO exec sp_dboption N'My_vehicle', N'autoclose', N'true' GO exec sp_dboption N'My_vehicle', N'bulkcopy', N'false' GO exec sp_dboption N'My_vehicle', N'trunc. log', N'true...
[title] [varchar](255) COLLATE Chinese_PRC_CI_AS NULL, [details] [text] COLLATE Chinese_PRC_CI_AS NULL, [imgs] [varchar](5000) COLLATE Chinese_PRC_CI_AS NULL, [classify] [varchar](50) COLLATE ...
[code] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [mtr] [ID] NOT NULL , [batch] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [vehicle] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT ...
[mobile] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [Msg] [nvarchar] (160) COLLATE Chinese_PRC_CI_AS NULL , [state] [int] NULL , [sendyorn] [int] NOT NULL , [sendtime] [datetime] NULL , ...
[username] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [password] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [firstname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [lastname] ...
[mobile] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [Msg] [nvarchar] (160) COLLATE Chinese_PRC_CI_AS NULL , [state] [int] NULL , [sendyorn] [int] NOT NULL , [sendtime] [datetime] NULL , ...
[ConsigneeName] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, [HomePhone] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, [Mobile] nvarchar(30) COLLATE Chinese_PRC_CI_AS NULL, [Country] nvarchar(50) ...
[User_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [Password] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [WorkID] [float] NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo]....
[Id] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [Name] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [Sex] [char](10) COLLATE Chinese_PRC_CI_AS NULL, [Weight] [float] NULL, [IsValid] ...
[Name] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [ParentItem] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [SecNum] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO
[id] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [tit] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [mes] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO 表中 id是节点...
[user_ID] [varchar] (15) COLLATE Chinese_PRC_CI_AS NOT NULL , [user_PWD] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL , [user_Des] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO ...
[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [card] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [xueli] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [price] [decimal](18, 0) NULL ...
[自编号] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, [员工编号] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [员工姓名] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [基本工资] [float] ...
[AppplyNo] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, [FileType] [varchar](2) COLLATE Chinese_PRC_CI_AS NOT NULL, [remark] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_...
[L_ZBB_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [L_ZBB_yyyy] [int] NULL , [L_ZBB_mm] [int] NULL , [L_ZBB_dd] [int] NULL , [L_ZBB_BZ] [varchar] (25) COLLATE Chinese_PRC_CI_AS NULL ) ...