1、递归查询

  Orcale 10g

    select level, m.pid,m.nodename,m.nodemark nodemark,m.parentid,m.nodeurl,m.classname
      from (select distinct m.pid pid,m.nodename nodename,m.nodemark nodemark,m.parentid parentid,m.nodeurl nodeurl,
          m.classname classname,ordernum from bs_t_sm_menutree m, bs_t_sm_rolemenutree rm where m.pid = rm.menuid
          and m.status = 1 and rm.roleid in = ?) m start with parentid = '0' connect by parentid = prior pid order siblings by m.ordernum

  SQL Server 2008: with myTb as(select pid,nodename,nodemark,parentid,nodeurl,classname,ordernum, cast(right(100000 + ordernum,5) as            varchar(1000)) as dns, 1 as level  from BS_V_SM_MENUBYROLE m where m.roleid in =? and m.parentid = '0'  union all  select                b.pid,b.nodename,b.nodemark,b.parentid,b.nodeurl,b.classname,b.ordernum, cast(myTb.dns+'-'+cast(right(100000+b.ordernum,5) as varchar(5))       as varchar(1000)) as dns, level+1 as level from myTb inner join BS_V_SM_MENUBYROLE b on myTb.pid=b.parentid and b.roleid in = ?) select        distinct * from myTb t order by t.dns

2、排序:

  1、按照汉字的拼音排序:

  Oracle 10g: select * from bs_t_sm_user t order by nlssort(t.fullname, 'NLS_SORT=SCHINESE_PINYIN_M');

  SQL Server 2008: select * from bs_t_sm_user t order by t.fullname COLLATE Chinese_PRC_CS_AS_KS_WS

posted @ 2012-07-06 15:25 shouma 阅读(213) 评论(0) 推荐(0)
摘要: 在Win7旗舰版上装SQL Server 2008 R2废了老劲了,总是弹出错误窗口“在创建窗口句柄之前,不能在控件上调用 Invoke 或 BeginInvoke”。从网上搜了半天资料终于找到一个靠谱的,修改注册表: 在HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager中找到PendingFileRenameOperations,将其值改为空字符串。 亲测通过。希望可以帮到正在受折磨的朋友们。 阅读全文
posted @ 2012-07-03 17:15 shouma 阅读(5203) 评论(0) 推荐(0)
摘要: 用imp命令从库A导出dmp再导入到,另外一个库B时报错: IMP-00017: 由于 ORACLE 错误 959, 以下语句失败:"CREATE TABLE "BS_T_FORM_TEMPLATE_VERSIONS" ("PID" VARCHAR2(50) NOT NULL ENA""BLE, "TEMPLATEID" VARCHAR2(50), "VERSION" VARCHAR2(10), "VERSIONNAME" VARCH""AR2( 阅读全文
posted @ 2012-06-01 14:00 shouma 阅读(9215) 评论(0) 推荐(0)
摘要: 在iframe子页面获取父页面元素代码如下:$('#Id', parent.document);在父页面 获取iframe子页面的元素代码如下:$("#Id",window.document.frames('iframename').document); 阅读全文
posted @ 2012-05-23 13:07 shouma 阅读(442) 评论(0) 推荐(0)
摘要: function selectAll(checked) { // 以ssss开头并且以xxxx结束 $(":checkbox[id^='ssss'][id$='xxxx']").each(function(){ $(this).attr("checked", checked); }); // 以ss 阅读全文
posted @ 2012-05-23 13:06 shouma 阅读(15929) 评论(0) 推荐(0)
点击右上角即可分享
微信分享提示