随笔分类 - SQLServer
摘要：2个单引号，代表一个字符 VALUES (|'+ TransformationName + '|）'，用|替换掉上面的'' 原始的sql是Values('+name+'),正常的情况拼接，拼接的时候，需要把原来的单引号，替换成两个单引号。 本来的','需要先转义成'',''来，然后再在外部分别加上'
阅读全文
摘要：https://social.msdn.microsoft.com/Forums/sqlserver/en-US/99bbcb47-d4b5-4ec0-9e91-b1a23a655844/ssms-2012-extremely-slow-expanding-databases?forum=sqlto
阅读全文
摘要：类型映射 https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql-server-data-type-mappings C#关键字 decimal https://docs.microsoft.com/en-us/dotnet
阅读全文
摘要：被谁锁住了 tbm_cih_CustomTableItemHistory_Product 是数据表的表名 如何解锁 http://www.cnblogs.com/shy1766IT/p/6225694.html 扩展 从sys.dm_tran_locks筛选的时候，主要是匹配resource_typ
阅读全文
摘要：SET ANSI_WARNINGS (Transact-SQL) https://docs.microsoft.com/en-us/sql/t-sql/statements/set-ansi-warnings-transact-sql The SQL Server Native Client ODB
阅读全文
摘要：https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6e20fa7a-c0a9-496b-89b2-19c6bd996ffc/how-to-collapse-object-explorer-tree-in-management-studi
阅读全文
摘要：https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/database-console-commands DBCC CHECKIDENT (Transact-SQL) https://docs.microsoft.c
阅读全文
摘要：http://vyaskn.tripod.com/differences_between_set_and_select.htm https://stackoverflow.com/questions/3945361/set-versus-select-when-assigning-variables
阅读全文
摘要：https://docs.microsoft.com/en-us/sql/t-sql/language-elements/logical-operators-transact-sql Logical operators test for the truth of some condition. Lo
阅读全文
摘要：https://stackoverflow.com/questions/10417126/dynamically-named-temp-table-returns-invalid-object-name-when-referenced-in-st You are doing it wrong! Tr
阅读全文
摘要：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
阅读全文
摘要：Back up 1,右键选中需要备份的数据库，Tasks-->Backup 2.General中，Destination，先remove掉之前的，然后再Add 需要注意的是，add的文件，必须要以.bak为后缀名，否则后面restore的话，不会显示出备份的文件 Restore 1.在数据库服务器的
阅读全文
摘要：https://docs.microsoft.com/en-us/sql/relational-databases/scripting/sqlcmd-start-the-utility C:\Users\clu>sqlcmd -?Microsoft (R) SQL Server Command Li
阅读全文
摘要：解决方法：不要用Administrator权限打开sql server
阅读全文
摘要：https://stackoverflow.com/questions/1535914/import-bak-file-to-a-database-in-sql-server On SQL Server Management Studio Right click Databases on left
阅读全文
摘要：Sorting the view based on frequency in SQL Server Just like in sub queries, you can't use ORDER BY in a view definition in sql server unless you also
阅读全文
