inside microsoft sql server 2005 tsql programming外语英文电子书

《inside microsoft sql server 2005 tsql programming外语英文电子书》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、InsideMicrosoftSQLServer2005T-SQLProgrammingInsideMicrosoftSQLServer2005—T-SQLProgrammingTableOfContents1.TableofContents62.BackCover73.InsideMicrosoftSQLServer2005—T-SQLProgramming84.Foreword135.Preface146.Introduction166.1SystemRequirement

2、s166.2InstallingSampleDatabases176.3Updates176.4CodeSamples176.5SupportforThisBook177.Chapter1:Datatype-RelatedProblems,XML,andCLRUDTs187.1DATETIMEDatatypes187.2Character-RelatedProblems417.3LargeObjects477.4ImplicitConversions517.5CLR-BasedUser-Defined

3、Types557.6XMLDataType797.7Conclusion968.Chapter2:TemporaryTablesandTableVariables968.1TemporaryTables978.2TableVariables1068.3tempdbConsiderations1108.4TableExpressions1118.5ComparisonSummary1128.6SummaryExercise—RelationalDivision1138.7Conclusion

4、1189.Chapter3:Cursors1199.1UsingCursors1209.2CursorOverhead1219.3DealingwithEachRowIndividually1229.4Order-BasedAccess123545InsideMicrosoftSQLServer2005—T-SQLProgramming9.5Conclusion14610.Chapter4:DynamicSQL14710.1EXEC14810.2sp_executesql15710.3En

5、vironmentalSettings16010.4UsesofDynamicSQL16110.5SQLInjection18110.6Conclusion18811.Chapter5:Views18911.1ORDERBYinaView19011.2RefreshingViews19411.3ModularApproach19611.4UpdatingViews20611.5ViewOptions21011.6IndexedViews21411.7Conclusion21812.Chapter6:U

6、ser-DefinedFunctions21812.1SomeFactsAboutUDFs21912.2ScalarUDFs22012.3Table-ValuedUDFs24612.4Per-RowUDFs25912.5Conclusion26213.Chapter7:StoredProcedures26313.1TypesofStoredProcedures26313.2TheStoredProcedureInterface27213.3Resolution27813.4Compilations,R

7、ecompilations,andReuseofExecutionPlans27913.5ExecuteAs29113.6ParameterizingSortOrder29213.7DynamicPivot29813.8CLRStoredProcedures31013.9Conclusion31914.Chapter8:Triggers31914.1AFTERTriggers320545InsideMicrosoftSQLServer2005—T-SQLProgramming14.2INS

8、TEADOFTriggers34014.3DDLTriggers34914.4CLRTriggers35714.5Conclusion36715.Chapter9:Transactions36715.1WhatAreTransactions?36815.2Locks37015.3IsolationLevels37615.4SavePoints38515.5Deadlocks38715.6Conclusion39416.Chapter10:Exceptio