Chuck Lu

摘要： 先从表里面筛选数据，并且添加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 阅读全文