knife_yu的专栏

由于设计需要，需要查询不重复的记录值。例如有如下表结构和值tablefid   name sex1     a      男2     b      男3     c      女4     d      女5     a      男6     b      男方案一：dist

oracle下:update housea a set a.extendinfo=(select b.extendinfo from houseb b where a.houseid=b.houseid) where a.isimage=1 and a.extendinfo is

sql查询区分大小写2009-09-12 08:421.--区分大小写 select * from a where a=’AbCdE’ collate Chinese_PRC_CS_AI--区分大小写 select * from a where a=’abCdE’ collate

1.sql按月进行查询select   *   from   yourtable   where   year(yourdatefield)='2009'   and   month(yourdatefield)='5' 2.sql按两个月份之间查询SELECT *FROM in

SQLServer：SELECT * FROM dept ORDER BY name COLLATE Chinese_PRC_CS_AS_KS_WSOracle ： 1. //按照笔划排序select * from dept order by nlssort(name,'NLS_

获取某字段或几个字段有重复的数据，可限定重复几条 select field1,field2 from table group by field1,field2 having count(field1)>1 获取某字段不重复的最新记录 select top * from table a where id in(select max(id) from table b group by

use 数据库名 go select a.Name as tableName from sysobjects a inner join syscolumns b on a.id=b.id where b.Name=‘字段名’

1、与sql2000连接字串： Set Conn = Server.CreateObject("ADODB.Connection") connstr="Provider=SqlOLEDB;Data Source=服务器IP(本地为local);initial catalog=数据库名;user ID=用户名;password=密码;" Conn.Open connstr     2、与