摘要:
'or substring(user,1,1)!='a' and 'a'!='b 将' 替换为空 阅读全文
摘要:
1: 新建分割函数 CREATE Function [dbo].[GetSplitTxt]( @String nvarchar(max), --要分割的字符串 @Split nvarchar(10), --分隔符号 @Num int --取第几个,最左边默认为第1个)returns nvarchar 阅读全文
摘要:
USE [GomeCPS]GO/****** Object: StoredProcedure [dbo].[proc_DataPagination] Script Date: 01/21/2016 15:58:06 ******/SET ANSI_NULLS ONGOSET QUOTED_I... 阅读全文
摘要:
替换 字段值里里面固定的内容UPDATE ActiveBase set imgLink =REPLACE (imgLink,'10.2.62.55' , '10.144.26.101') WHERE activeSource =1删除重复项select *FROM ( SELECT Row_Num... 阅读全文
摘要:
控制器:var existProductDic = new Dictionary(); foreach (var item in merSingleList) { int a = BLL.existespecialShop(i... 阅读全文
摘要:
控制器:public ActionResult DataSummary() { shopno = ShopLogin.LoginUser.ShopNo; List vDataSummaryList = EffectListMap(true, ... 阅读全文
摘要:
exec sp_addlinkedserver @server = N'LinkServer2', @srvproduct = N' ', @provider = N'SQLOLEDB', @datasrc = N'127.0.0.1', 访问的ip地址 @catalog... 阅读全文
摘要:
GO/****** Object: StoredProcedure [dbo].[proc_Data] Script Date: 12/10/2015 18:17:12 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO/********... 阅读全文
摘要:
select *FROM ( SELECT Row_Number() OVER ( PARTITION BY [OrderNum] ORDER BY ( SELECT 0) ) AS RowNO , *FROM [GomeCPS].[dbo].[a17]) t WHERE T.Ro... 阅读全文
摘要:
2.0 list = ViewData["list"] as List; %> 0) {%> ... 阅读全文