目前分類:MSSQL (5)
- Mar 07 Thu 2019 17:51
【T-SQL】取倒數n筆資料
- Apr 18 Thu 2013 18:08
【T-SQL】從磁碟中匯入資料BULK INSERT
想重A DB 取全部0R部分 新增到 B DB內,找了一些相關資料關於批次搬移資料的方式,其中我選擇BULK INSERT(依照使用者指定的格式,將資料檔匯入資料庫資料表或檢視表中。),語法如下:
1: BULK INSERT
2: [ database_name . [ schema_name ] . | schema_name . ] [ table_name | view_name ]
3: FROM 'data_file'
4: [ WITH
5: (
6: [ [ , ] BATCHSIZE = batch_size ]
7: [ [ , ] CHECK_CONSTRAINTS ]
8: [ [ , ] CODEPAGE = { 'ACP' | 'OEM' | 'RAW' | 'code_page' } ]
9: [ [ , ] DATAFILETYPE =
10: { 'char' | 'native'| 'widechar' | 'widenative' } ]
11: [ [ , ] FIELDTERMINATOR = 'field_terminator' ]
12: [ [ , ] FIRSTROW = first_row ]
13: [ [ , ] FIRE_TRIGGERS ]
14: [ [ , ] FORMATFILE = 'format_file_path' ]
15: [ [ , ] KEEPIDENTITY ]
16: [ [ , ] KEEPNULLS ]
17: [ [ , ] KILOBYTES_PER_BATCH = kilobytes_per_batch ]
18: [ [ , ] LASTROW = last_row ]
19: [ [ , ] MAXERRORS = max_errors ]
20: [ [ , ] ORDER ( { column [ ASC | DESC ] } [ ,...n ] ) ]
21: [ [ , ] ROWS_PER_BATCH = rows_per_batch ]
22: [ [ , ] ROWTERMINATOR = 'row_terminator' ]
23: [ [ , ] TABLOCK ]
24: [ [ , ] ERRORFILE = 'file_name' ]
- Jan 04 Fri 2013 15:35
【T-SQL】標準差(Standard Deviation)STDEV、STDEVP函數
今天智魔王殺進辦公室,需要標準差宛妞當場做不出來,加上他一直看我,緊張之下做不出來.,就這樣算是被考倒了,丟臉…只好再複習,再接再厲米米給我建議要我先做出來的時候沒做,哈哈今天要寫出來才能離開辦公室了!!
++++++++++++++++++++
- Oct 25 Thu 2012 17:00
【MSSQL】資料庫還原到另一台server,使用者對應語法(sp_change_users_login)
- Aug 27 Mon 2012 12:24
莫名的想改ssms設定-單一伺服器連接