作者:搬主 / 日期:2013/12/03 / 分类:MsSql / 阅读:476
select * from tb_aftermarket where order_number in (select order_number from tb_aftermarket group by order_number having count(order_number) > 1)
作者:搬主 / 日期:2013/12/03 / 分类:MsSql / 阅读:457
delete from tb_aftermarketwhere order_number in (select order_number from tb_aftermarket group by order_number having count(order_number) > 1)and id not in (select min(id) from tb_aftermarket gro...
作者:搬主 / 日期:2013/12/03 / 分类:C# / 阅读:537
& lt; < 小于号 & gt; > 大于号 & amp; & 和 & apos; 单引号& quot; " 双引号换行符‘\n’和回车符‘\r’
作者:搬主 / 日期:2013/12/03 / 分类:C# / 阅读:460
/// <summary>/// 检测订单状态/// </summary>/// <param name="OrderState"></param>public static string CheckOrderState(string OrderState){ string strResult = "...
作者:搬主 / 日期:2013/12/03 / 分类:MsSql / 阅读:627
--查找table_a 表中 id 字段中含有"a"或者"b"的记录.select * from table_a where charindex(a,id)>0 or charindex(b,id)>0select * from dbo.tbproduct where charindex(,43,,classid)...
作者:搬主 / 日期:2013/12/03 / 分类:Asp.Net / 阅读:515
<%# Container.ItemIndex + 1%><%# Container.ItemIndex + 1 + (this.page-1)*this.pageSize %>
作者:搬主 / 日期:2014/03/23 / 分类:C# / 阅读:650
//using System.Text.RegularExpressions;//1、用字符串分隔: string str = "aaajsbbbjsccc";string[] sArray = Regex.Split(str, "js", RegexOptions.IgnoreCase);foreach (string i in sAr...
«上一页 1 ... 31 32 33