2014年4月21日
Declare Cusror of SQLServer
摘要： Defines the attributes of a Transact-SQL server cursor, such as its scrolling behavior and the query used to build the result set on which the cursor ... 阅读全文
posted @ 2014-04-21 23:40 princessd8251 阅读(348) 评论(0) 推荐(0) 编辑
T-SQL User-Defined Functions: the good, the bad, and the ugly (part 1)
摘要： So you thought that encapsulating code in user-defined functions for easy reuse is a good idea? Think again!SQL Server supports three types of user-de... 阅读全文
posted @ 2014-04-21 16:49 princessd8251 阅读(273) 评论(0) 推荐(0) 编辑
Top 20 dictionary views
摘要： fromhttp://www.dbaref.com/top-20-dictionary-views1. V$SESSIONV$SESSIONdisplays session information for each current session.ColumnDatatypeDescriptionS... 阅读全文
posted @ 2014-04-21 00:23 princessd8251 阅读(228) 评论(0) 推荐(0) 编辑