diandi4511-CSDN博客

转载 Sql Server 获取本周周一

SELECT DATEADD(Day,(@i+1)-(DATEPART(Weekday,getdate())+@@DATEFIRST-1)%7,getdate())转载于:https://www.cnblogs.com/RambleLife/p/9858679.html

2018-10-26 20:54:00 749

转载 sql server 计算两个时间相差的几天几时几分几秒

CAST ( CAST ( DATEDIFF ( ss, StartTime, ConcludeTime ) / ( 60 * 60 * 24 ) AS INT ) AS VARCHAR ) + '天' + CAST ( CAST ( DATEDIFF ( ss, StartTime, ConcludeTime ) % 86400 / 3600 AS INT ) AS VARCHA...

2018-10-22 17:46:00 1905

转载 sql server 通用修改表数据存储过程

ALTER PROC [dbo].[UpdateTableData]@TableName VARCHAR(255),@SearchField VARCHAR(255),@SearchValue VARCHAR(255),@WhereField VARCHAR(255),@WhereValue VARCHAR(255)AS BEGINDECLARE @s...

2018-10-22 16:26:00 365

转载查询表数据通用存储过程

SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROC [dbo].[SearchTableData]@TableName VARCHAR(255),@Fields VARCHAR(255),@WhereField VARCHAR(255),@WhereValue VARCHAR(255)...

2018-10-22 16:22:00 221

转载 CodeSmith生成实体类

<%@ CodeTemplate Language="C#" TargetLanguage="C#" ResponseEncoding="UTF-8" Debug="False" Description="生成数据库实体" %><%@ Property Name="SourceTable" Type="SchemaExplorer.TableSchema" Ca...

2018-10-12 15:37:00 85

转载 visual studio 启动无法打开IIS express

删除解决方案下的vs文件夹之后重新生成转载于:https://www.cnblogs.com/RambleLife/p/9766314.html

2018-10-10 14:48:00 159

转载获取url查询参数的方法

/** * 获取url查询参数的方法 * @param name * @returns {null} * @constructor */function GetQueryString(name) { var reg = new RegExp("(^|&)"+ name +"=([^&]*)(&|$)"); var r...

2018-10-04 11:31:00 86

转载 Unknown initial character set index '255' received from server. Initial client character set can be

mysql的连接错误，在网上查找到是编码不匹配的原因，直接在连接的URL后加上?useUnicode=true&characterEncoding=utf8就可以了转载于:https://www.cnblogs.com/RambleLife/p/9603813.html...

2018-09-07 12:09:00 90

转载 mysql Client does not support authentication protocol requested by server; consider upgrading MySQL

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';转载于:https://www.cnblogs.com/RambleLife/p/9603808.html

2018-09-07 12:07:00 104

转载高性能JavaScript模板引擎 artTemplate

下载地址<!DOCTYPE html><html><head> <meta charset="utf-8" /> <title></title> <script src="js/template.js"></script></head&...

2018-09-03 16:23:00 84

转载 Sql Server中查询当天，最近三天，本周，本月，最近一个月，本季度的数据的sql语句...

--当天：select * from T_news where datediff(day,addtime,getdate())=0--最近三天：select * from T_news where datediff(day,addtime,getdate())<= 2 and datediff(day,addtime,getdate())>= 0...

2018-09-01 20:45:00 1043

转载 entity framework异常 The specified cast from a materialized 'System.Int32' type to the 'System.Strin...

ROW_NUMBER() OVER (ORDER BY (select Null)) AS Id entity framework 查询中有这句会有异常转载于:https://www.cnblogs.com/RambleLife/p/9571437.html

2018-09-01 20:08:00 678

转载游标和递归sql 的一些代码

DECLARE @UserID INT; --推广员帐号DECLARE @ProxyID INT; --代理帐号DECLARE @Score INT=1000; --分数SELECT @UserID = [SpreaderID]FROM [QPAccountsDB].[dbo].[AccountsInfo]WHERE UserID =...

2018-08-20 19:52:00 139

转载 sql server递归

with cte as(select belongsAgent from [QPProxyDB].[dbo].[BS_ProxyInfo] where ProxyID = @ProxyID union allselect a.ProxyID from [QPProxyDB].[dbo].[BS_ProxyInfo] a join cte b on a.ProxyID ...

2018-08-20 17:07:00 100

转载统计分页一些sql

USE [QPTreasureDB]GO/****** Object: StoredProcedure [dbo].[GameStatistics] Script Date: 2018/8/16 10:33:10 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROC [dbo].[Ga...

2018-08-16 10:35:00 82

转载解决SQL Server本地Windows身份无法登录

CREATE LOGIN [计算机名\Windows帐户名] FROM WINDOWS转载于:https://www.cnblogs.com/RambleLife/p/9217567.html

2018-06-23 16:30:00 1186

转载查询当前数据库存在某个字符串的存储过程

--将text替换成你要查找的内容 SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%AgentRoomCardOrder%' AND ROUTINE_TYPE='PROCEDURE'转载于:ht...

2018-06-21 16:02:00 129

转载 C#检测本机是否联网

public class Net { [DllImport("wininet")] private extern static bool InternetGetConnectedState(out int connectionDescription, int reservedValue); /// <summary> ...

2018-06-16 10:10:00 139

转载 C#检测U盘是否插入

public partial class Form1 : Form { #region u盘属性 public const int WM_DEVICECHANGE = 0x219;//U盘插入后，OS的底层会自动检测到，然后向应用程序发送“硬件设备状态改变“的消息 public const int DBT_DEV...

2018-06-16 10:03:00 642

转载 log4Net辅助类

public class Log { private ILog logger; public Log(ILog log) { this.logger = log; } public void Debug(object message) {...

2018-06-11 01:56:00 56

转载 Log4Net记录到文件

将这篇文章的配置文件中的log4net节点下的内容替换成下面的https://www.cnblogs.com/RambleLife/p/9165248.html<log4net debug="false"> <root> <priority value="ALL"/> <appender-ref ...

2018-06-11 01:48:00 95

转载 Log4Net记录到数据库

WinForm下Log4Net的配置Log4Net 组件下载地址https://download.csdn.net/download/zgx123zgx123zg/10470986configSections节点下添加  <section name="log4net" type="log4net.Con...

2018-06-11 01:38:00 167

转载 ASP.NET登录验证

protected void btnLogin_Click(object sender, EventArgs e) { string username = txtUserName.Value.Trim(); string userpassword = txtUserPassword.Value.Trim();...

2018-05-24 10:15:00 146

转载 ASP.NET判断是否为手机登录

protected void Page_Load(object sender, EventArgs e) { MobileHandle(); }页面加载时候判断是否为手机登录 protected void MobileHandle() { ...

2018-05-24 09:49:00 258

转载 sql server复制表数据到另外一个表的存储过程

if exists (select * from sysobjects where id=object_id('GenerateData') and OBJECTPROPERTY(id, 'IsProcedure') =1 ) Drop Procedure GenerateDatagoCREATE PROCEDURE GenerateData @tabl...

2018-05-19 20:40:00 426

转载检测到在集成的托管管道模式下不适用的 ASP.NET 设置

system.webServer节点下加上 <validation validateIntegratedModeConfiguration="false" />转载于:https://www.cnblogs.com/RambleLife/p/9031519.html

2018-05-13 11:17:00 99

转载调用百度翻译API接口功能

public string appid = "自己的APPID"; public string q = "要翻译的文本"; public string salt = "1435660288"; public string key = "你的密钥"; public string from = "你的源语言例如...

2018-05-11 19:46:00 575

转载 C#操作json

C#操作json的LitJson.dllhttps://download.csdn.net/download/pukuimin1226/5851711读取json//UserInfo.json[ {"id":"1","name":"叶良辰","age": "20"}, {"id":"2","name":"赵日天","age": "25"}]...

2018-05-11 12:15:00 77

转载 sql server 2008 身份验证失败 18456

双击打开后加上 ;-m 然后以管理员方式打开 SQLSERVER 2008 就可以已window身份登录不过还没有完右键属性 =》安全性更改为 sql server 和 window身份验证模式没有sql server登陆账号的话创建一个然后把-m去掉就可以用帐号登录了转载于:https://www.cnblogs...

2018-05-10 11:41:00 190

转载 MD5密码加密

using System;using System.Security.Cryptography;using System.Text;namespace DimoNetwork.Common.DEncrypt{ public enum MD5ResultMode : byte { Strong = 0, Wea...

2018-04-20 10:52:00 58

转载 Sql Server2008R2下载地址

ed2k://%7Cfile%7Ccn_sql_server_2008_r2_enterprise_x86_x64_ia64_dvd_522233.iso%7C4662884352%7C1DB025218B01B48C6B76D6D88630F541%7C/转载于:https://www.cnblogs.com/RambleLife/p/8877006.html

2018-04-18 19:10:00 554

转载网站样式

公告http://www.htmleaf.com/Demo/201707014606.html左导航http://www.htmleaf.com/Demo/201605023416.html转载于:https://www.cnblogs.com/RambleLife/p/8417687.html

2018-02-05 15:11:00 58

转载 C#读取AD域用户信息

private const string domainName = "本机IP地址或域名"; private const string adAdmin = "管理员帐号"; private const string password = "管理员密码"; private const string ouN...

2018-01-28 10:43:00 1327

转载 SharePoint读取配置文件

配置文件存放目录C:\inetpub\wwwroot\wss\VirtualDirectories\80\web.config读取配置string Name=Configuration.WebConfigurationManager.AppSettings["Name"];转载于:https://www.cnblogs.com/RambleLife/p/8267712.h...

2018-01-11 12:05:00 122

转载 vs2017 未能完成操作。不支持此接口

打开vs2017开发者命令提示符切换至安装下的指定目录执行下面的命令就可以了需要注意的是一定要用vs2017的开发人员命令提示符别用cmdgacutil -i Microsoft.VisualStudio.Shell.Interop.11.0.dll转载于:https://www.cnblogs.com/RambleLife/p/8227721.h...

2018-01-07 12:11:00 667

转载 InfoPath读取数据库

public void LoadBtn_Clicked(object sender, ClickedEventArgs e) { // 配置连接字符串 using (SqlConnection con = new SqlConnection("Data Source=sps;Initial Cata...

2018-01-02 17:18:00 117

转载 InfoPath读取List到重复表

标题设置好了添加一个按钮更改ID 点击编写代码然后添加引用并更改下域的名字添加如下代码public void LoadBtn_Clicked(object sender, ClickedEventArgs e) { // 在此处编写代码。 //创建集合用于存储数据...

2018-01-02 16:28:00 138

转载 AD域创建用户无法登录

怎么登录都无法登录解决办法：创建用户的时候将用户下次登录时须更改密码的勾去掉不然需要修改密码才可以登录转载于:https://www.cnblogs.com/RambleLife/p/8033914.html...

2017-12-13 17:11:00 1869

空空如也

空空如也