摘要:
目前有个字段如下:希望写一个排序第二个‘-’左边的按照字符串排序,右边的按照数字排序 档案号B10-1-40B10-1-5B10-1-6B10-1-7实现sql格式如下:select * from tablename order by left(档案号,charindex('-',档案号,chari... 阅读全文
摘要:
function ExisitBrower() { var BR = ""; var Sys = {}; var ua = navigator.userAgent.toLowerCase(); var s; (s = ua.match(/msie ([\d.]+)/)) ? Sys.ie = s[1] : (s = ua.match(/firefox\/([\d.]+)/)) ? Sys.firefox = s[1] : (s = ua.match(/chrome\/([\d.]+)/)) ? Sys.chrome = s[1] : (s = ua.match(/opera 阅读全文
摘要:
表uc_diary与uc_photo是两个完全不相关的表,用union all可以将这里个表的数据关联到一起,使用时间排序,常用于新鲜事的显示,讲日志,相册,说说等动态放到一起,安装时间排序select diary_id as id, diary_title as title, diary_text as contentandname, post_time, 'diary' as type from uc_diary wherediary_state='0' AND emp_id='eedc8ae7-be7b-41d6-8887-283804d6... 阅读全文