S- Q- L- Server2005-中的十个最重要的- T-- S- Q- L增强功能课件.pptxVIP

SQLServer2005中的十个最重要的T-SQL增强功能;讲座的总体内容:;参加讲座的前提条件;讲座议程;Newsystemdefineddatatypes

AlsocapabilitytodefineuserdefineddatatypesusingCLR–separatesession.;Similarinbehaviortothesmallercounterparts

TextpointersupportwillberemovedinafutureversionofSQLServer.Werecommendconvertingyourtext,ntextandimagecolumnstothenewlarge-valuedatatypes.;Newsystemdefineddatatypes

AlsocapabilitytodefineuserdefineddatatypesusingCLR–separatesession.;关于错误处理的提高;TRY…CATCH;TRY…CATCH–(继续);1=ActiveCommittableTransaction

0=NoActiveTransactions

-1=Active