摘要：
转自http://www.mssqltips.com/sqlservertip/1715/scheduling-a-sql-server-profiler-trace/ProblemYou want to schedule a trace, but SQL Profiler does not hav... 阅读全文
posted @ 2014-04-16 22:30
princessd8251
阅读(311)
评论(0)
推荐(0)
摘要：
转自http://rusanu.com/2009/06/11/exception-handling-and-nested-transactions/I wanted to use a template for writing procedures that behave as intuitively... 阅读全文
posted @ 2014-04-16 22:22
princessd8251
阅读(134)
评论(0)
推荐(0)
摘要：
使用整数数据的精确数字数据类型。bigint从 -2^63 (-9223372036854775808) 到 2^63-1 (9223372036854775807) 的整型数据（所有数字）。存储大小为 8 个字节。int从 -2^31 (-2,147,483,648) 到 2^31 - 1 (2,... 阅读全文
posted @ 2014-04-16 22:18
princessd8251
阅读(253)
评论(0)
推荐(0)
摘要：
question:if the nested transaction encountered an exception, then rollbacked. How about the outer transaction?Lets demo this using below code.create p... 阅读全文
posted @ 2014-04-16 21:43
princessd8251
阅读(499)
评论(0)
推荐(0)
摘要：
转自http://blog.sqlauthority.com/2009/12/15/sql-server-difference-temptable-and-table-variable-temptable-in-memory-a-myth/Recently, I have been conducti... 阅读全文
posted @ 2014-04-16 21:07
princessd8251
阅读(248)
评论(0)
推荐(0)
摘要：
转自 http://www.mssqltips.com/sqlservertip/2825/sql-server-temp-table-vs-table-variable-performance-testing/ProblemIf you've been a DBA for any amount o... 阅读全文
posted @ 2014-04-16 20:45
princessd8251
阅读(699)
评论(0)
推荐(0)
摘要：
转自http://www.mssqltips.com/sqlservertip/1556/differences-between-sql-server-temporary-tables-and-table-variables/ProblemI've heard of table variables,... 阅读全文
posted @ 2014-04-16 20:44
princessd8251
阅读(269)
评论(0)
推荐(0)
浙公网安备 33010602011771号