12 2017 档案

摘要:https://docs.microsoft.com/en-us/sql/t-sql/data-types/date-and-time-types date (Transact-SQL)datetime (Transact-SQL)datetime2 (Transact-SQL)datetimeof 阅读全文
posted @ 2017-12-29 15:23 ChuckLu 阅读(347) 评论(0) 推荐(0) 编辑
摘要:https://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins How can a LEFT OUTER JOIN return more records than exist in the left tab 阅读全文
posted @ 2017-12-28 16:17 ChuckLu 阅读(166) 评论(0) 推荐(0) 编辑
摘要:https://docs.microsoft.com/en-us/sql/t-sql/functions/datediff-transact-sql 返回值是,用结束时间,减去开始时间 阅读全文
posted @ 2017-12-26 13:43 ChuckLu 阅读(237) 评论(0) 推荐(0) 编辑
摘要:在Nuget中,添加Microsoft.CodeDom.Providers.DotNetCompilerPlatform。 在添加这个dll的时候,会自动在web.config中添加以下内容 这个dll本身还依赖Microsoft.Net.Compilers (>= 2.4.0)。 最终的packa 阅读全文
posted @ 2017-12-26 11:11 ChuckLu 阅读(701) 评论(0) 推荐(0) 编辑
摘要:先从表里面筛选数据,并且添加RowNumber列,把这个筛选结果作为result 然后从result中进行二次筛选,通过pagesize和pageindex来进行分页 generate row numbers in the same order the data are added. 从表里筛选数据 阅读全文
posted @ 2017-12-22 16:40 ChuckLu 阅读(488) 评论(0) 推荐(0) 编辑
摘要:方法1 https://stackoverflow.com/questions/2334712/how-do-i-update-from-a-select-in-sql-server 方法2 https://stackoverflow.com/questions/1068447/update-wit 阅读全文
posted @ 2017-12-20 18:49 ChuckLu 阅读(286) 评论(0) 推荐(0) 编辑
摘要:SQL Server loop - how do I loop through a set of records By using T-SQL and cursors like this : https://stackoverflow.com/questions/28506747/sql-loop- 阅读全文
posted @ 2017-12-20 10:32 ChuckLu 阅读(606) 评论(0) 推荐(0) 编辑
摘要:https://docs.microsoft.com/en-us/sql/t-sql/language-elements/control-of-flow The Transact-SQL control-of-flow language keywords are: 阅读全文
posted @ 2017-12-20 10:22 ChuckLu 阅读(174) 评论(0) 推荐(0) 编辑
摘要:http://api.jquery.com/jquery.ajax/ http://www.runoob.com/jquery/jquery-ref-ajax.html type (default: 'GET') Type: String An alias for method. You shoul 阅读全文
posted @ 2017-12-19 09:56 ChuckLu 阅读(238) 评论(0) 推荐(0) 编辑
摘要:https://documentation.red-gate.com/soc6/common-tasks/exclude-objects-using-filters 如果有人上传了filter,name需要在sql source control的Get Latest的选项卡中pull from re 阅读全文
posted @ 2017-12-18 12:17 ChuckLu 阅读(247) 评论(0) 推荐(0) 编辑
摘要:https://docs.microsoft.com/en-us/visualstudio/debugger/remote-debugging https://docs.microsoft.com/en-us/visualstudio/debugger/remote-debugging-csharp 阅读全文
posted @ 2017-12-14 11:22 ChuckLu 阅读(194) 评论(0) 推荐(0) 编辑
摘要:1.设置服务器上的windows service的security,下面的命令只能用cmd.exe来运行(以管理员模式) sc sdset "LISA_43_Dev_Batch" "D:(A;;CCLCSWRPWPDTLOCRRC;;;SY)(A;;CCDCLCSWRPWPDTLOCRSDRCWDW 阅读全文
posted @ 2017-12-14 09:53 ChuckLu 阅读(697) 评论(0) 推荐(0) 编辑
摘要:https://stackoverflow.com/questions/2728578/how-to-get-phyiscal-path-of-windows-service-using-net https://www.codeproject.com/Articles/26533/A-Service 阅读全文
posted @ 2017-12-11 18:43 ChuckLu 阅读(296) 评论(0) 推荐(0) 编辑
摘要:打开SiteManager,选择Settings,然后左上角选择具体的网站,Content,Web Site Content,Default alias path 阅读全文
posted @ 2017-12-08 10:28 ChuckLu 阅读(209) 评论(0) 推荐(0) 编辑
摘要:https://docs.kentico.com/k10/securing-websites/developing-secure-websites/handling-error-messages-securely/creating-custom-error-handling-pages 阅读全文
posted @ 2017-12-07 18:10 ChuckLu 阅读(141) 评论(0) 推荐(0) 编辑
摘要:https://docs.microsoft.com/en-us/iis/troubleshoot/using-failed-request-tracing/troubleshooting-failed-requests-using-tracing-in-iis https://docs.micro 阅读全文
posted @ 2017-12-07 17:46 ChuckLu 阅读(1239) 评论(0) 推荐(0) 编辑
摘要:2个单引号,代表一个字符 VALUES (|'+ TransformationName + '|)',用|替换掉上面的'' 原始的sql是Values('+name+'),正常的情况拼接,拼接的时候,需要把原来的单引号,替换成两个单引号。 本来的','需要先转义成'',''来,然后再在外部分别加上' 阅读全文
posted @ 2017-12-06 17:02 ChuckLu 阅读(2724) 评论(0) 推荐(0) 编辑
摘要:https://msdn.microsoft.com/en-us/library/bb727008.aspx On NTFS volumes, you can set security permissions on files and folders. These permissions grant 阅读全文
posted @ 2017-12-06 16:32 ChuckLu 阅读(274) 评论(0) 推荐(0) 编辑
摘要:https://docs.microsoft.com/en-us/dotnet/api/system.directoryservices?view=netframework-4.7 The System.DirectoryServices namespace provides easy access 阅读全文
posted @ 2017-12-05 17:47 ChuckLu 阅读(569) 评论(0) 推荐(0) 编辑
摘要:Authenticated Users System Administrators Users 假如一个用户属于2个用户组的话,deny的优先级更高 log在写文件的时候,如果没有权限访问。会遇到UnauthorizedAccessException,这个异常需要直接抛出到顶层 获取当前用户 获取当 阅读全文
posted @ 2017-12-05 16:04 ChuckLu 阅读(1071) 评论(0) 推荐(0) 编辑
摘要:https://stackoverflow.com/questions/9654833/how-to-run-visual-studio-as-administrator-by-default Windows 8, 8.1 and 10 In Windows 8, you have to right 阅读全文
posted @ 2017-12-05 10:32 ChuckLu 阅读(1060) 评论(0) 推荐(0) 编辑
摘要:https://stackoverflow.com/questions/12859891/error-unable-to-access-the-iis-metabase 解决方法1 On Windows 8 Pro: %systemroot%\inetsrv\config On Windows 7 阅读全文
posted @ 2017-12-05 10:08 ChuckLu 阅读(472) 评论(0) 推荐(0) 编辑
摘要:https://docs.microsoft.com/en-us/dotnet/framework/performance/caching-in-net-framework-applications Caching enables you to store data in memory for ra 阅读全文
posted @ 2017-12-04 14:35 ChuckLu 阅读(295) 评论(0) 推荐(0) 编辑
摘要:How to: Enable Default Paging in the GridView Web Server Control https://msdn.microsoft.com/en-us/library/y71xk4a7(v=vs.100).aspx To enable paging in 阅读全文
posted @ 2017-12-04 09:58 ChuckLu 阅读(403) 评论(0) 推荐(0) 编辑
摘要:HTTP Error 500.19 - internal server error when you open an IIS Webpage HRESULT code 0x8007000d Error message: Server Error in Application "application 阅读全文
posted @ 2017-12-03 18:54 ChuckLu 阅读(1508) 评论(0) 推荐(0) 编辑
摘要:https://www.wikihow.com/Block-a-Program-with-Windows-Firewall 打开windows firewall change settings 然后就可以修改权限配置了 阅读全文
posted @ 2017-12-01 15:11 ChuckLu 阅读(349) 评论(0) 推荐(0) 编辑
摘要:使用F12进行监视 本身是一个linkbutton,可以看到绑定了一个JavaScript <a id="gvStaticConnection_ctl02_fresh" href="javascript:__doPostBack('gvStaticConnectionctl02fresh','' 阅读全文
posted @ 2017-12-01 14:19 ChuckLu 阅读(611) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示