改变sqlserver2000排序规则
来源:互联网 发布:电器设计软件 编辑:程序博客网 时间:2024/05/16 18:53
CREATE PROCEDURE SP_TW_TO_PRC
@TypeName VARCHAR(255)
,@OldCollation VARCHAR(255)
,@NewCollation VARCHAR(255)
AS
SET NOCOUNT ON
DECLARE @TmpTab TABLE
(
SID INT IDENTITY(1,1)
,TabName VARCHAR(255)
,ColName VARCHAR(255)
,[PRECISION] VARCHAR(10)
)
INSERT INTO @TmpTab(TabName, ColName, [PRECISION])
SELECT OBJECT_NAME(id) as TabName ,NAME as ColName, prec FROM syscolumns
WHERE id IN
(
SELECT id FROM sysobjects WHERE xtype='u' AND name <> 'dtproperties'
)
AND xtype IN
(
SELECT xtype FROM systypes
WHERE name = @TypeName
)
AND collation = @OldCollation
ORDER BY id, colid
DECLARE @MaxCount INT
,@SID INT
,@strSQL VARCHAR(8000)
SELECT @SID = 1, @MaxCount = MAX(SID) FROM @TmpTab
WHILE @SID <= @MaxCount BEGIN
SELECT @strSQL = 'ALTER TABLE ' + TabName
+ ' ALTER COLUMN ' + ColName
+ ' ' + @TypeName +
CASE @TypeName
WHEN 'text' THEN ''
WHEN 'ntext' THEN ''
ELSE '(' + [PRECISION] + ')'
END
+ ' COLLATE ' + @NewCollation
FROM @TmpTab
WHERE SID = @SID
PRINT @strSQL
EXEC(@strSQL)
SET @SID = @SID + 1
END
RETURN 0
go
SP_TW_TO_PRC 'varchar','Chinese_Taiwan_Stroke_CI_AS','Chinese_PRC_CI_AS'
go
IF EXISTS(SELECT * FROM SYSOBJECTS WHERE NAME='SP_TW_TO_PRC' AND XTYPE='p')
DROP PROCEDURE SP_TW_TO_PRC
@TypeName VARCHAR(255)
,@OldCollation VARCHAR(255)
,@NewCollation VARCHAR(255)
AS
SET NOCOUNT ON
DECLARE @TmpTab TABLE
(
SID INT IDENTITY(1,1)
,TabName VARCHAR(255)
,ColName VARCHAR(255)
,[PRECISION] VARCHAR(10)
)
INSERT INTO @TmpTab(TabName, ColName, [PRECISION])
SELECT OBJECT_NAME(id) as TabName ,NAME as ColName, prec FROM syscolumns
WHERE id IN
(
SELECT id FROM sysobjects WHERE xtype='u' AND name <> 'dtproperties'
)
AND xtype IN
(
SELECT xtype FROM systypes
WHERE name = @TypeName
)
AND collation = @OldCollation
ORDER BY id, colid
DECLARE @MaxCount INT
,@SID INT
,@strSQL VARCHAR(8000)
SELECT @SID = 1, @MaxCount = MAX(SID) FROM @TmpTab
WHILE @SID <= @MaxCount BEGIN
SELECT @strSQL = 'ALTER TABLE ' + TabName
+ ' ALTER COLUMN ' + ColName
+ ' ' + @TypeName +
CASE @TypeName
WHEN 'text' THEN ''
WHEN 'ntext' THEN ''
ELSE '(' + [PRECISION] + ')'
END
+ ' COLLATE ' + @NewCollation
FROM @TmpTab
WHERE SID = @SID
PRINT @strSQL
EXEC(@strSQL)
SET @SID = @SID + 1
END
RETURN 0
go
SP_TW_TO_PRC 'varchar','Chinese_Taiwan_Stroke_CI_AS','Chinese_PRC_CI_AS'
go
IF EXISTS(SELECT * FROM SYSOBJECTS WHERE NAME='SP_TW_TO_PRC' AND XTYPE='p')
DROP PROCEDURE SP_TW_TO_PRC
- 改变sqlserver2000排序规则
- set改变排序规则
- fastjson排序问题-如何改变fastjson的排序规则
- MS sqlserver2000 master库语言排序规则不一致导致的问题
- SQLserver2000 字段排序
- 排序规则
- 【转】 【NLSSORT】改变Oralce 对简体汉字的排序规则(拼音、部首、笔画)
- SqlServer2000
- SqlServer2000
- SQLServer2000
- 无法改变规则,那就改变自己
- git .gitignore 无法改变规则
- 容器改变着开发规则
- 【转】 【ORDER】改变Oralce对简体汉字的排序规则(拼音、部首、笔画)(session级调整)
- 不同排序规则数据库排序
- SQLSERVER的排序规则
- sql排序规则
- SQL排序规则
- MyEclipse 快捷键大全
- 展讯平台-LCD驱动
- Cassandra1.0.x实用教程
- Android Eclipse 源码工程 调试
- JAVA语言,谈谈其独特之处
- 改变sqlserver2000排序规则
- 请各位C++大牛说说项目怎么合理的管理文件
- Android FrameWork概述
- JVM垃圾回收机制总结(1) :一些概念
- html5较于xhtml的优点
- 如何更好的读别人写的代码
- 过滤敏感字的算法
- Windows程序调试系列文章——Windbg轻松上路
- CE6 CPU 使用率