- 博客(8)
- 收藏
- 关注
原创 Functional Dependencies & MultiValued Dependency
Functional Dependencies (FDs) 1->1A->B: If I know your vendor code, I can determine the vendor nameMultiValued Dependency (MVD) 1 -> *A->->B: If I know the customer code, I can determine the list of t
2007-12-10 10:16:00 918
原创 Database normal form
1 NF=====================================================================Acolumn is atomic, not array, no repeating semantic columnsanti-example:Customers(CustID INT, CustName VARCHAR(30)...)SQL 2005
2007-12-10 10:15:00 618
原创 SQL 2005 DataWarehouse Note
@2007 June 02MS BI Studiofact table (transaction table)dim table (master file: product, customer)BI Studio1)Datasource: Delphi ADOConnection2)Datasource View: ADOTable3)Cube4)Dimensionmainly involve:
2007-12-10 09:15:00 726
原创 Error checking V.S. Exception
1)Error checkingif (bad_condition) thenbegin ShowMsg("bad"); return ERROR_CODE_1;end; 2)raise exceptionif (bad_condition) then raise Exception.Create("bad")comparision:1)communicate with UI d
2007-12-10 08:46:00 626
原创 关于SQL Server的ISOLATION
ISOLATION 是Connection的一个property,每个session都有自己的Isolation Level1)Read Uncommitted (不做控制)能读别人已修改未提交的databegin traninsert(can read data)2)Read committed不能读别人已修改未提交的databegin traninsert直到commit(can read d
2007-12-10 08:34:00 860
转载 Locking in Microsoft SQL Server (Quoted from mssqlcity)
Locking in Microsoft SQL ServerAlexander Chigrikchigrik@mssqlcity.comIntroductionTransaction Isolation LevelsLock typesLocking optimizer hintsDeadlocksView locks (sp_lock)LiteratureIntroductionIn this
2007-12-10 08:25:00 970
原创 C# terminate thread with stop variable
namespace FrameworkTest{ public partial class Form1 : Form { private bool stopThread = false; delegate void InsertListCallback(int index, object item); private void btnStart
2007-12-07 08:57:00 1145
原创 T-SQL Nested procedure & transactions
IF OBJECT_ID(sp_ThrowExp) IS NOT NULL DROP PROC sp_ThrowExpGOCREATE PROC sp_ThrowExpAS RAISERROR(Error occurs., 16, 1)GOIF OBJECT_ID(sp_OuterProc) IS NOT NULL DROP PROC sp_OuterProcGOC
2007-12-06 14:31:00 632
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人