Chuck Lu

摘要： How to rollback a transaction in a stored procedure? 执行的存储过程需要transaction的话，在调用的时候传入 如果有事务锁定了数据库，那么可以直接rollback 在执行存储过程的的时候，错误提示 You attempted to acqu 阅读全文

摘要： Cursors (Transact-SQL) Microsoft SQL Server statements produce a complete result set, but there are times when the results are best processed one row 阅读全文

摘要： https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql Conversion failed when converting the varchar value ' ' to data typ 阅读全文

摘要： nodes() Method (xml Data Type) https://docs.microsoft.com/en-us/sql/t-sql/xml/nodes-method-xml-data-type The nodes() method is useful when you want to 阅读全文

摘要： WITH common_table_expression (Transact-SQL) Specifies a temporary named result set, known as a common table expression (CTE). This is derived from a s 阅读全文

摘要： NuGet behind a proxy 回答1 Here's what I did to get this working with my corporate proxy that uses NTLM authentication. I downloaded NuGet.exe and then 阅读全文

摘要： https://documentation.red-gate.com/display/SOC5/SQL+Source+Control+5+documentation SELECT DB_NAME(DatabaseID) AS DatabaseName , UserName , * FROM dbo. 阅读全文

摘要： 计算机原理 ABC三个输入 每一个输入，拆分成2路，对应到1和0。通过一个非门来实现。 一个有6个线路，123456 有8个输出，每一个输出，对应3个线路。 阅读全文

摘要： https://www.zhihu.com/question/27462267/answer/204658544 https://gist.github.com/adeekshith/cd4c95a064977cdc6c50 # <type>: (If applied, this commit wi 阅读全文

摘要： New-Service https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.management/new-service?view=powershell-5.1 PS C:\Program Files\Pow 阅读全文