abs636636-CSDN博客

转载 sql 注入

'or substring(user,1,1)!='a' and 'a'!='b 将' 替换为空转载于:https://www.cnblogs.com/fu123/p/5418509.html

2016-04-21 20:08:00 85

转载 sql 字段值拆分更新

1：新建分割函数 CREATE Function [dbo].[GetSplitTxt]( @String nvarchar(max), --要分割的字符串 @Split nvarchar(10), --分隔符号 @Num int --取第几个，最左边默认为第1个)returns...

2016-02-23 14:05:00 184

转载 sql分页存储过程有排序

USE [GomeCPS]GO/****** Object: StoredProcedure [dbo].[proc_DataPagination] Script Date: 01/21/2016 15:58:06 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO /****************************...

2016-01-21 16:00:00 105

转载常用SQL 语句

替换字段值里里面固定的内容 UPDATE ActiveBase set imgLink =REPLACE (imgLink,'10.2.62.55' , '10.144.26.101') WHERE activeSource =1 删除重复项 select *FROM ( SELECT Row_Number() OVER ( PARTITION BY [OrderNum...

2016-01-21 15:55:00 201

转载 mvc ViewData["existProductDic"] 数据字典便利

控制器： var existProductDic = new Dictionary<string, bool>(); foreach (var item in merSingleList) { int a = BLL.existespecialShop(item.ProID, item.Sku_...

2016-01-20 19:30:00 84

转载 mvc和 Echarts报表展示 ajax前后台数据交互

控制器： public ActionResult DataSummary() { shopno = ShopLogin.LoginUser.ShopNo; List<Result> vDataSummaryList = EffectListMap(true, shopno); View_D...

2016-01-20 19:26:00 194

转载 sql 跨服务器导入数据

exec sp_addlinkedserver @server = N'LinkServer2', @srvproduct = N' ', @provider = N'SQLOLEDB', @datasrc = N'127.0.0.1', 访问的ip地址 @catalog = N'GomeCPS'; exec sp_addlinkedsrvlogin ...

2016-01-18 16:33:00 81

转载 sql 分页存储过程及其调用

GO/****** Object: StoredProcedure [dbo].[proc_Data] Script Date: 12/10/2015 18:17:12 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO /**************************************************...

2016-01-18 16:30:00 96

转载 sql server 去掉重复项

select *FROM ( SELECT Row_Number() OVER ( PARTITION BY [OrderNum] ORDER BY ( SELECT 0) ) AS RowNO , *FROM [GomeCPS].[dbo].[a17]) t WHERE T.RowNO > 1 ; select * From [GomeCPS].[dbo]....

2016-01-18 16:27:00 142

转载 mvc2.0与3.0 便利一行三个元素便利多行代码

2.0 <% List<GomeCps.Entity.EntityVO.EarnerInfosVO> list = ViewData["list"] as List<GomeCps.Entity.EntityVO.EarnerInfosVO>; %> <% if(list != null &...

2016-01-18 16:26:00 92

转载 JS导入Excel

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><script src="Scr...

2016-01-18 16:22:00 88

转载 c# 接口访问的两种方式get 和post

private JsonMessage WebRequest(string type, string paramData) { string postUrl = string.Empty; if (type == "Get" || type == "Delete") postUrl = apiUrl...

2016-01-18 16:19:00 290

abs636636的博客