摘要: Top:sql中:select top 10 * from tablenamePOS中:select * from tablename limit 10获取当前时间:sql:getdate()pos:now()判断函数是否为nullsql: isnull(字段名,0)pos:COALESCE(字段名,0)创建自动增长列pos:1.创建一个序列语法:CREATE SEQUENCE "EnvSetting_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;ALTER TABLE &q 阅读全文
posted @ 2012-03-30 16:53 猪特曼 阅读(257) 评论(0) 推荐(0) 编辑