PowerDeisnger16下导出到sqlserver2005以上出现sysproperties错误的解决办法
来源:互联网 发布:如何用手机注册淘宝号 编辑:程序博客网 时间:2024/04/30 12:35
[if exists (select 1
from sys.extended_properties
where major_id = object_id('[%QUALIFIER%]%TABLE%')
and minor_id = 0)
begin
[%OWNER%?[.O:[execute ][exec ]]sp_dropextendedproperty [%R%?[N]]'MS_Description',
[%R%?[N]]'user', [%R%?[N]]%.q:OWNER%, [%R%?[N]]'table', [%R%?[N]]%.q:TABLE%
:declare @CurrentUser sysname
select @CurrentUser = user_name()
[.O:[execute ][exec ]]sp_dropextendedproperty [%R%?[N]]'MS_Description',
[%R%?[N]]'user', [%R%?[N]]@CurrentUser, [%R%?[N]]'table', [%R%?[N]]%.q:TABLE%
]
end
][%OWNER%?[.O:[execute ][exec ]]sp_addextendedproperty [%R%?[N]]'MS_Description',
[%R%?[N]]%.q:COMMENT%,
[%R%?[N]]'user', [%R%?[N]]%.q:OWNER%, [%R%?[N]]'table', [%R%?[N]]%.q:TABLE%
:select @CurrentUser = user_name()
[.O:[execute ][exec ]]sp_addextendedproperty [%R%?[N]]'MS_Description',
[%R%?[N]]%.q:COMMENT%,
[%R%?[N]]'user', [%R%?[N]]@CurrentUser, [%R%?[N]]'table', [%R%?[N]]%.q:TABLE%
]
---------------------------------ColumnComment-----------------------------
[if exists (select 1
from sys.extended_properties
where major_id= object_id('[%QUALIFIER%]%TABLE%')
and value = [%R%?[N]]%.q:COMMENT%)
begin
[%OWNER%?[.O:[execute ][exec ]]sp_dropextendedproperty [%R%?[N]]'MS_Description',
[%R%?[N]]'user', [%R%?[N]]%.q:OWNER%, [%R%?[N]]'table', [%R%?[N]]%.q:TABLE%, [%R%?[N]]'column', [%R%?[N]]%.q:COLUMN%
:declare @CurrentUser sysname
select @CurrentUser = user_name()
[.O:[execute ][exec ]]sp_dropextendedproperty [%R%?[N]]'MS_Description',
[%R%?[N]]'user', [%R%?[N]]@CurrentUser, [%R%?[N]]'table', [%R%?[N]]%.q:TABLE%, [%R%?[N]]'column', [%R%?[N]]%.q:COLUMN%
]
end
][%OWNER%?[.O:[execute ][exec ]]sp_addextendedproperty [%R%?[N]]'MS_Description',
[%R%?[N]]%.q:COMMENT%,
[%R%?[N]]'user', [%R%?[N]]%.q:OWNER%, [%R%?[N]]'table', [%R%?[N]]%.q:TABLE%, [%R%?[N]]'column', [%R%?[N]]%.q:COLUMN%
:select @CurrentUser = user_name()
[.O:[execute ][exec ]]sp_addextendedproperty [%R%?[N]]'MS_Description',
[%R%?[N]]%.q:COMMENT%,
[%R%?[N]]'user', [%R%?[N]]@CurrentUser, [%R%?[N]]'table', [%R%?[N]]%.q:TABLE%, [%R%?[N]]'column', [%R%?[N]]%.q:COLUMN%
]
视图改动如下:
原先的脚本:
[if exists (select 1
from sysproperties
where id = object_id('[%QUALIFIER%]%VIEW%')
and type = 3)
begin
[%OWNER%?[.O:[execute ][exec ]]sp_dropextendedproperty [%R%?[N]]'MS_Description',
[%R%?[N]]'user', [%R%?[N]]%.q:OWNER%, [%R%?[N]]'table', [%R%?[N]]%.q:VIEW%
:declare @CurrentUser sysname
select @CurrentUser = user_name()
[.O:[execute ][exec ]]sp_dropextendedproperty [%R%?[N]]'MS_Description',
[%R%?[N]]'user', [%R%?[N]]@CurrentUser, [%R%?[N]]'view', [%R%?[N]]%.q:VIEW%
]
end
][%OWNER%?[.O:[execute ][exec ]]sp_addextendedproperty [%R%?[N]]'MS_Description',
[%R%?[N]]%.q:COMMENT%,
[%R%?[N]]'user', [%R%?[N]]%.q:OWNER%, [%R%?[N]]'table', [%R%?[N]]%.q:VIEW%
:select @CurrentUser = user_name()
[.O:[execute ][exec ]]sp_addextendedproperty [%R%?[N]]'MS_Description',
[%R%?[N]]%.q:COMMENT%,
[%R%?[N]]'user', [%R%?[N]]@CurrentUser, [%R%?[N]]'view', [%R%?[N]]%.q:VIEW%
]
改为:
[if exists (select 1
from sys.extended_properties
where major_id = object_id('[%QUALIFIER%]%VIEW%')
and minor_id = 3)
- PowerDeisnger16下导出到sqlserver2005以上出现sysproperties错误的解决办法
- SqlServer2005/2008下sysproperties无效的解决办法
- 安装sqlserver2005时出现的计数器错误
- 连接到SQLServer2005时出现的问题
- 导出Excel时出现80080005错误的解决办法
- SQLserver2005出现17051错误
- ubuntu下用su切换到root用户时用 gedit会出现错误的解决办法
- sqlserver2005及以上版本导出表结构
- 针对ADT升级到17以上出现NoClassDefFoundError问题的解决办法
- Xcode升级到7.1出现itms-90049 错误 的解决办法
- androidstudio git项目到github出现的错误解决办法
- androidstudio git项目到github出现的错误解决办法
- sqlserver2005新建登录名时的15195错误解决办法
- WindowXP下安装RMagick出现R6034错误的解决办法
- Ubuntu下安装bochs出现错误的解决办法
- linux下tomcat配置cronolog出现的一些错误解决办法!
- php5.4下安装ECshop出现错误的解决办法
- ubuntu下apache虚拟主机出现forbidden错误的解决办法
- 揭秘生姜价格贵过猪肉的背后
- emwin,动起来,小小计算器
- ubuntu下配置rsync服务
- cydia添加源程序 v1.1.6 中文版
- 打印机驱动安装一则
- PowerDeisnger16下导出到sqlserver2005以上出现sysproperties错误的解决办法
- Android init进程启动
- 公钥和私钥
- 转换ipa中得图片
- 面试题之两个字符串
- 智能指针 std::auto_ptr 和 shared_ptr
- UCGUI上MULTIPAGE画线等图形实现办法
- 多线程的优先级处理
- 阿里巴巴:从未把余额宝当成战略级产品