Amber's Lab

Data Type

SQL Server (SqlClient)

Oracle (OracleClient)

DT_BOOL

bit

 

DT_BYTES

binary, varbinary, timestamp

raw

DT_CY

smallmoney, money

 

DT_DATE

date

 

DT_DBDATE

date

 

DT_DBTIME

 
 

DT_DBTIMESTAMP

datetime, smalldatetime

timestamp, date, interval

DT_DECIMAL

decimal

 

DT_FILETIME

 
 

DT_GUID

uniqueidentifier

 

DT_I1

 
 

DT_I2

smallint

 

DT_I4

int

 

DT_I8

bigint

 

DT_NUMERIC

decimal, numeric

number, int

DT_R4

real

 

DT_R8

float

float, real

DT_STR

char, varchar

 

DT_UI1

tinyint

 

DT_UI2

 
 

DT_UI4

 
 

DT_UI8

 
 

DT_WSTR

char, varchar, nchar, nvarchar, sql_variant, xml

char, rowid, varchar2, nvarchar2, nchar

DT_IMAGE

image

long raw, blob,loblocator, bfile, vargraphic, long vargraphic, user-defined

DT_NTEXT

text, ntext

long, clob, nclob, nvarchar, text

DT_TEXT

text

 

SharePoint2010 的錯誤訊息查看方式：
將【相互關聯識別碼】複製
進入SharePoint主機中：C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS
點選xxx.log，搜尋時使用【相互關聯識別碼】為關鍵字即可查到錯誤訊息的內容。

SSIS錯誤訊息：
[ADO NET 來源 [2348]] 錯誤: System.BadImageFormatException: 不是正確的 Win32 應用程式 。 (發生例外狀況於 HRESULT: 0x800700C1)
於 Microsoft.Data.SAPClient.SAPConnection.Open()
於 Microsoft.SqlServer.Dts.Runtime.ManagedHelper.GetManagedConnection(String assemblyQualifiedName, String connStr, Object transaction)
於 Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager100.AcquireConnection(Object pTransaction)
於 Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction)
於 Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper100 wrapper, Object transaction)
解決方式：
於專案上按右鍵→屬性→組態屬性→偵錯→偵錯選項→Run64BitRuntime改為False

DateTime st = DateTime.Now;
DateTime ed = DateTime.Now;
TimeSpan ts = ed.Subtract(st);
string output = String.Format("{0:00}:{1:00}:{2:00}", ts.TotalHours, ts.Minutes, ts.Seconds);

//時間與字串之間的轉換
//時間轉字串
string datestring = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss ffff")
string datestring = DateTime.Now.ToString("s", System.Globalization.DateTimeFormatInfo.InvariantInfo)
"s" 代表Sortable格式 "yyyy/MM/ddTHH:mm:ss"

//字串轉時間
DateTime st = DateTime.Parse(datestring);

/* 防止撐開 IE*/
table-layout: fixed;
/* 防止撐開 FX*/
overflow: auto;

/* 英文單字自動換行 IE ONLY*/
word-wrap: break-word;

/* 正常避頭尾 */
word-break: normal;

/* 文字左右對齊 */
text-align:justify;
text-justify:inter-ideograph;

參數說明
maxlength：字串的最大長度
UPDATE TABLE
SET <column> = REPLICATE( '<string>' , maxlength - LEN(<column>)) + <column>

 
SET STATISTICS TIME { ON | OFF }
 
SET STATISTICS TIME ON
<SQL>
SET STATISTICS TIME OFF