摘要:
1、查看表和视图SELECT * FROM sys.objects WHERE object_id = object_id('表名或视图名')在sqlserver中一般可通过查询sys.objects系统表来得知结果,不过可以有更方便的方法 如下: if object_id('tb_table') 阅读全文
摘要:
查询ORACLE字符集 --select userenv('language') from dual; --select * from v$nls_parameters; --select * from nls_database_parameters; --select * from sys.props$; mysql:show variables like '%char%'; SQLSE... 阅读全文
摘要:
oracle select * from ( select rownum as rn,HDMS.HD_PURGE_STATUS.* from HDMS.HD_PURGE_STATUS where rownum 10 and rn2) YY; MySQL select * from sakila.actor limit 10,10; 数据量大时,2个参数limit性能有影响,用如下:vid是表... 阅读全文