![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Database
__Kevin__
淡泊名利,宁静致远
展开
-
Inside SQL Server 2005 -- T-SQL Querying read note
TBD原创 2010-04-22 18:08:00 · 450 阅读 · 0 评论 -
DB Skills -- Autocommit
Sybase: 1. Links 2. A way to avoid autocommit without setting optoin "chaineddeclare cursor_o cursor forselect distinct yld_id from tempdb..yield_listgoopen cursor_odeclare @yld原创 2010-04-26 13:40:00 · 394 阅读 · 0 评论 -
Index and Statistics
<br />Two mechanisms work together to optimize database queries<br /> <br />Sybase Manual:<br />http://dcx.sybase.com/SA12_bd_en/dbreference_en12/create-statistics-statement.html<br /> <br />Tips:<br />1. In Sybase 15.0, there are global indexes created au原创 2010-11-10 17:14:00 · 472 阅读 · 0 评论 -
UDF (User-defined Function)
<br />Sybase 15.0 or above supports UDF原创 2010-11-10 17:17:00 · 544 阅读 · 0 评论 -
Sybase - Useful sqls
<br />1. Copy records from table A to table B<br />insert into tableA<br />select * from table B where {conditions}原创 2010-11-15 10:34:00 · 339 阅读 · 0 评论 -
[SQL Server] 批量插入数据
在做大量数据流处理时,我们经常会遇到批量插入记录的情况,下面收录一些1. Bcp1> 创建一个DataTable(schema应和对应的DB Table一致), 或者创建一些临时表2>向数据表中注入我们的数据3>按照以下办法Call Bcp 4> 完成SqlConnection原创 2011-07-19 09:46:29 · 1476 阅读 · 0 评论 -
[DB Skills & Experience]Notes on alter DB object schema
1. alter table. When a table is being altered, all the operations on it will fail or be locked.原创 2012-02-21 10:08:07 · 390 阅读 · 0 评论