摘要:
用于批量删除和添加数据 1.停用全部外键 select 'ALTER TABLE '+o.name+' NOCHECK CONSTRAINT '+fk.name+';' AS Command from sys.foreign_keys fk JOIN sys.all_objects o ON (fk 阅读全文
摘要:
1。。。ifnull nullif2.。。。分页:limit 10 , 3 select * from (select row_number() over (order by id) rownum) nn where nn.rownum between 1 and 1+103.。分页 :limit 阅读全文