假设有表 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...【阅读全文】
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'[...【阅读全文】