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
阅读全文
摘要: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
阅读全文
摘要:https://docs.microsoft.com/en-us/sql/t-sql/functions/datediff-transact-sql 返回值是,用结束时间,减去开始时间
阅读全文
摘要:在Nuget中,添加Microsoft.CodeDom.Providers.DotNetCompilerPlatform。 在添加这个dll的时候,会自动在web.config中添加以下内容 这个dll本身还依赖Microsoft.Net.Compilers (>= 2.4.0)。 最终的packa
阅读全文
摘要:先从表里面筛选数据,并且添加RowNumber列,把这个筛选结果作为result 然后从result中进行二次筛选,通过pagesize和pageindex来进行分页 generate row numbers in the same order the data are added. 从表里筛选数据
阅读全文
摘要:方法1 https://stackoverflow.com/questions/2334712/how-do-i-update-from-a-select-in-sql-server 方法2 https://stackoverflow.com/questions/1068447/update-wit
阅读全文
摘要: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-
阅读全文
摘要:https://docs.microsoft.com/en-us/sql/t-sql/language-elements/control-of-flow The Transact-SQL control-of-flow language keywords are:
阅读全文
摘要: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
阅读全文
摘要:https://documentation.red-gate.com/soc6/common-tasks/exclude-objects-using-filters 如果有人上传了filter,name需要在sql source control的Get Latest的选项卡中pull from re
阅读全文
摘要:https://docs.microsoft.com/en-us/visualstudio/debugger/remote-debugging https://docs.microsoft.com/en-us/visualstudio/debugger/remote-debugging-csharp
阅读全文
摘要:1.设置服务器上的windows service的security,下面的命令只能用cmd.exe来运行(以管理员模式) sc sdset "LISA_43_Dev_Batch" "D:(A;;CCLCSWRPWPDTLOCRRC;;;SY)(A;;CCDCLCSWRPWPDTLOCRSDRCWDW
阅读全文
摘要:https://stackoverflow.com/questions/2728578/how-to-get-phyiscal-path-of-windows-service-using-net https://www.codeproject.com/Articles/26533/A-Service
阅读全文
摘要:打开SiteManager,选择Settings,然后左上角选择具体的网站,Content,Web Site Content,Default alias path
阅读全文
摘要:https://docs.kentico.com/k10/securing-websites/developing-secure-websites/handling-error-messages-securely/creating-custom-error-handling-pages
阅读全文
摘要:https://docs.microsoft.com/en-us/iis/troubleshoot/using-failed-request-tracing/troubleshooting-failed-requests-using-tracing-in-iis https://docs.micro
阅读全文
摘要:2个单引号,代表一个字符 VALUES (|'+ TransformationName + '|)',用|替换掉上面的'' 原始的sql是Values('+name+'),正常的情况拼接,拼接的时候,需要把原来的单引号,替换成两个单引号。 本来的','需要先转义成'',''来,然后再在外部分别加上'
阅读全文
摘要:https://msdn.microsoft.com/en-us/library/bb727008.aspx On NTFS volumes, you can set security permissions on files and folders. These permissions grant
阅读全文
摘要:https://docs.microsoft.com/en-us/dotnet/api/system.directoryservices?view=netframework-4.7 The System.DirectoryServices namespace provides easy access
阅读全文
摘要:Authenticated Users System Administrators Users 假如一个用户属于2个用户组的话,deny的优先级更高 log在写文件的时候,如果没有权限访问。会遇到UnauthorizedAccessException,这个异常需要直接抛出到顶层 获取当前用户 获取当
阅读全文
摘要: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
阅读全文
摘要:https://stackoverflow.com/questions/12859891/error-unable-to-access-the-iis-metabase 解决方法1 On Windows 8 Pro: %systemroot%\inetsrv\config On Windows 7
阅读全文
摘要:https://docs.microsoft.com/en-us/dotnet/framework/performance/caching-in-net-framework-applications Caching enables you to store data in memory for ra
阅读全文
摘要: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
阅读全文
摘要:HTTP Error 500.19 - internal server error when you open an IIS Webpage HRESULT code 0x8007000d Error message: Server Error in Application "application
阅读全文
摘要:https://www.wikihow.com/Block-a-Program-with-Windows-Firewall 打开windows firewall change settings 然后就可以修改权限配置了
阅读全文
摘要:使用F12进行监视 本身是一个linkbutton,可以看到绑定了一个JavaScript <a id="gvStaticConnection_ctl02_fresh" href="javascript:__doPostBack('gvStaticConnectionfresh',''
阅读全文