假设有表 Table1 ( name varchar(30) not null )有值: AA BB CC DD EE ...他们需要进行一个循环赛,写出SQL:Anwser:select t1.name, t2.namefrom Table1 t1, Table1 t2where t1.name < t2.name...【阅读全文】
最近协助用户升级IQ 软件版本,从IQ 15.4升级到IQ 16SP03 ,补丁成功安装后,更新IQ数据库系统表操作:alter database upgrade 出错。以下是错误信息:(DBA)> alter database upgradeDatabase upgrade startedCreating system viewsError in file systabviews.sql at line 972 with sqlcode -131Could n...【阅读全文】
How to check if triggers enabled?[69] HXHALODB1.dmo_govcorp.1> alter table formula disabletrigger formula_u;Disabling trigger 'formula_u'. The way to checkupdate trigger:[71] HXHALODB1.dmo_govcorp.1> select sysstat2 & 4194304 from sysobjects where name = 'formula'[...【阅读全文】