文件名称:Beginning_SQL_Server_2005_Express_for_Developers_F
介绍说明--下载内容均来自于网络,请自行研究使用
SQL Server 2005基础教程一书的源代码.
(系统自动生成,下载前可以参看下载内容)
下载文件列表
压缩包 : 107215791beginning_sql_server_2005_express_for_developers_from_novice_to_professional-3435.zip 列表 1-59059-720-6/Chapter01/ 1-59059-720-6/Chapter01/readme.txt 1-59059-720-6/Chapter02/ 1-59059-720-6/Chapter02/ReadMe.txt 1-59059-720-6/Chapter03/ 1-59059-720-6/Chapter03/CREATE DATABASE.sql 1-59059-720-6/Chapter04/ 1-59059-720-6/Chapter04/1-CREATE AJMASON.sql 1-59059-720-6/Chapter04/2-ALTER LOGIN.sql 1-59059-720-6/Chapter04/3-CREATE USER.sql 1-59059-720-6/Chapter04/4-CREATE SCHEMA Transactions.sql 1-59059-720-6/Chapter05/ 1-59059-720-6/Chapter05/1.CustomerDetails.Customers.sql 1-59059-720-6/Chapter05/2-TransactionDetails.sql 1-59059-720-6/Chapter05/3-TransactionTypes.sql 1-59059-720-6/Chapter05/4-AlterTable.sql 1-59059-720-6/Chapter05/5-RemainingTables.sql 1-59059-720-6/Chapter05/6-PrimaryKey.sql 1-59059-720-6/Chapter05/7-foreignKey.sql 1-59059-720-6/Chapter06/ 1-59059-720-6/Chapter06/1-CustomerIndex.sql 1-59059-720-6/Chapter06/2-OtherIndexes.sql 1-59059-720-6/Chapter06/3.Drop-Index.sql 1-59059-720-6/Chapter06/4.ShareDetails.SharePrices-Index.sql 1-59059-720-6/Chapter07/ 1-59059-720-6/Chapter07/1.SetDBOffline.sql 1-59059-720-6/Chapter07/10.RestoreLogT-SQL.sql 1-59059-720-6/Chapter07/11.DetachTSQL.sql 1-59059-720-6/Chapter07/12.AttachTSQL.sql 1-59059-720-6/Chapter07/2.SetDBOnline.sql 1-59059-720-6/Chapter07/3.FullBackup.sql 1-59059-720-6/Chapter07/4.DifferentialBackup.sql 1-59059-720-6/Chapter07/5.VerifyBackup.sql 1-59059-720-6/Chapter07/6.BackupTransactionLog.sql 1-59059-720-6/Chapter07/7.SetRecoveryMode.sql 1-59059-720-6/Chapter07/8.AlterTablePriorToTSQLRestore.sql 1-59059-720-6/Chapter07/9.RestoreT-SQLPart1.sql 1-59059-720-6/Chapter08/ 1-59059-720-6/Chapter08/1.InsertShareDetails.Shares.sql 1-59059-720-6/Chapter08/10.SELECT 3 Columns.sql 1-59059-720-6/Chapter08/11.SELECTAlias.sql 1-59059-720-6/Chapter08/12.InsertShareDetails.Shares.sql 1-59059-720-6/Chapter08/13.SELECTSpecificCompany.sql 1-59059-720-6/Chapter08/14.SELECTRanger.sql 1-59059-720-6/Chapter08/15.SELECTRowcount.sql 1-59059-720-6/Chapter08/16.SELECTTopVRowcount.sql 1-59059-720-6/Chapter08/17.SELECTConcatenation.sql 1-59059-720-6/Chapter08/18.SELECTConcatenationALIAS.sql 1-59059-720-6/Chapter08/19.SELECTWithOrder.sql 1-59059-720-6/Chapter08/2.FixupCustomerDetails.Customers.sql 1-59059-720-6/Chapter08/20.SELECTWithOrderDESC.sql 1-59059-720-6/Chapter08/21.SELECTWithLIKE.sql 1-59059-720-6/Chapter08/22.SELECTWithLIKE2.sql 1-59059-720-6/Chapter08/23.SELECT-ERROR.sql 1-59059-720-6/Chapter08/24.SELECTINTO.sql 1-59059-720-6/Chapter08/25-UpdateToBrodie.sql 1-59059-720-6/Chapter08/26-RetrieveBrodie.sql 1-59059-720-6/Chapter08/27-UPDATEbackToMcGlynn.sql 1-59059-720-6/Chapter08/28-SELECTMcGlynnAgain.sql 1-59059-720-6/Chapter08/29-UpdateClearedBalance.sql 1-59059-720-6/Chapter08/3.ConstraintCustomerDetails.CustomerProducts.sql 1-59059-720-6/Chapter08/30-SelectCustomer.sql 1-59059-720-6/Chapter08/31-DataTypeError.sql 1-59059-720-6/Chapter08/32-UPDATESharesInTran.sql 1-59059-720-6/Chapter08/33-UPDATERollbackTran.sql 1-59059-720-6/Chapter08/34 - NestedTransTrancount.sql 1-59059-720-6/Chapter08/35-RollbackDELETE.sql 1-59059-720-6/Chapter08/36-Delete3Rollback.sql 1-59059-720-6/Chapter08/37-TruncateCustomers.sql 1-59059-720-6/Chapter08/4.CheckConstraint.CustomerDetails.CustomerProducts.sql 1-59059-720-6/Chapter08/5.DefaultConstraint.CustomerDetails.CustomerProducts.sql 1-59059-720-6/Chapter08/6.CHECKCustomerDetails.CustomerProducts.sql 1-59059-720-6/Chapter08/7.MultipleINSERTs.sql 1-59059-720-6/Chapter08/8.SelectTOP3.sql 1-59059-720-6/Chapter08/9.SELECTALL.sql 1-59059-720-6/Chapter08/readme.txt 1-59059-720-6/Chapter09/ 1-59059-720-6/Chapter09/1.ShareDetails.Shares.view.sql 1-59059-720-6/Chapter09/10.CREATE INDEX on view.sql 1-59059-720-6/Chapter09/2.ShareDetails.vw_SharePrices.sql 1-59059-720-6/Chapter09/3-insert-shareprices.sql 1-59059-720-6/Chapter09/4.CustTrans-TSQL-Test.sql 1-59059-720-6/Chapter09/5.CustomerDetails.vw_CustTrans.sql 1-59059-720-6/Chapter09/6.Predata required for SCHEMA view.sql 1-59059-720-6/Chapter09/7.SCHEMABINDING TestCode.sql 1-59059-720-6/Chapter09/8.SCHEMABINDING View vw_CustFinProducts.sql 1-59059-720-6/Chapter09/9.DROPandRECREATE of view.sql 1-59059-720-6/Chapter09/readme.txt 1-59059-720-6/Chapter10/ 1-59059-720-6/Chapter10/00-DemonstratingValueInOUTPUT.sql 1-59059-720-6/Chapter10/1.FirstStoredProcedureCreation.sql 1-59059-720-6/Chapter10/2.RunningFirstProcedure.sql 1-59059-720-6/Chapter10/3.RunningSecondProcedure.sql 1-59059-720-6/Chapter10/4.SecondProcedureWithOUTPUT.sql 1-59059-720-6/Chapter10/5.BREAK.sql 1-59059-720-6/Chapter10/6.CASE-2-Example.sql 1-59059-720-6/Chapter10/6.CASEExample.sql 1-59059-720-6/Chapter10/7.FinalExampleAllTogether.sql 1-59059-720-6/Chapter10/readme.txt 1-59059-720-6/Chapter11/ 1-59059-720-6/Chapter11/1-JOIN.sql 1-59059-720-6/Chapter11/10-Variables-2batches.sql 1-59059-720-6/Chapter11/11-Variables-MultipleRows.sql 1-59059-720-6/Chapter11/12-TempTable.sql 1-59059-720-6/Chapter11/13-GlobalTempTable.sql 1-59059-720-6/Chapter11/13.Count.sql 1-59059-720-6/Chapter11/14.CountFilter.sql 1-59059-720-6/Chapter11/15-Sum.sql 1-59059-720-6/Chapter11/16-MaxMin.sql 1-59059-720-6/Chapter11/17-AVG.sql 1-59059-720-6/Chapter11/18-GROUPBY.sql 1-59059-720-6/Chapter11/19-GROUPBY-2.sql 1-59059-720-6/Chapter11/2-JOINonTwoColumns.sql 1-59059-720-6/Chapter11/20-HAVING.sql 1-59059-720-6/Chapter11/21-PREDISTINCT.sql 1-59059-720-6/Chapter11/22-DISTINCT-1.sql 1-59059-720-6/Chapter11/23-DISTINCT-2.sql 1-59059-720-6/Chapter11/24-DATEADD.sql 1-59059-720-6/Chapter11/25-DATEADD-SUBTRACTION.sql 1-59059-720-6/Chapter11/26-DATEDIFF.sql 1-59059-720-6/Chapter11/27-DATENAME.sql 1-59059-720-6/Chapter11/28-DATEPART.sql 1-59059-720-6/Chapter11/29-DATEFormatted.sql 1-59059-720-6/Chapter11/3.LEFT-OUTERJOIN.sql 1-59059-720-6/Chapter11/30-ASCII.sql 1-59059-720-6/Chapter11/31-CHAR.sql 1-59059-720-6/Chapter11/32-CHAR-2.sql 1-59059-720-6/Chapter11/33-LEFT.sql 1-59059-720-6/Chapter11/34-Lower.sql 1-59059-720-6/Chapter11/35-LTRIM.sql 1-59059-720-6/Chapter11/36-RIGHT.sql 1-59059-720-6/Chapter11/37-RTRIM.sql 1-59059-720-6/Chapter11/38-STR.sql 1-59059-720-6/Chapter11/39-LTRIM-AND-STR.sql 1-59059-720-6/Chapter11/4.LEFT-OUTERJOIN-WithNoPrice.sql 1-59059-720-6/Chapter11/40-SUBSTRING.sql 1-59059-720-6/Chapter11/41-UPPER.sql 1-59059-720-6/Chapter11/42-CASE.sql 1-59059-720-6/Chapter11/43-CAST.sql 1-59059-720-6/Chapter11/44-CONVERT.sql 1-59059-720-6/Chapter11/45-ISDATE.sql 1-59059-720-6/Chapter11/46-ISDATe-VALID.sql 1-59059-720-6/Chapter11/47-ISNULL.sql 1-59059-720-6/Chapter11/48-ISNUMERIC-FALSE.sql 1-59059-720-6/Chapter11/49-ISNUMERIC-TRUE.sql 1-59059-720-6/Chapter11/5.RIGHT-OUTERJOIN.sql 1-59059-720-6/Chapter11/50-spaddmessage.sql 1-59059-720-6/Chapter11/51-CustomerOverdrawn.sql 1-59059-720-6/Chapter11/52-sp_addmessage_chage.sql 1-59059-720-6/Chapter11/53-RAISEERROR-improved.sql 1-59059-720-6/Chapter11/54-DOUBLE-@@ERROR.sql 1-59059-720-6/Chapter11/55-RAISERROR-With-@@ERROR.sql 1-59059-720-6/Chapter11/56-RAISERROR-Severity11.sql 1-59059-720-6/Chapter11/57-TryCatch-1.sql 1-59059-720-6/Chapter11/58-TryCatch-2.sql 1-59059-720-6/Chapter11/59-TryCatch-3.sql 1-59059-720-6/Chapter11/6-InsertForTest.sql 1-59059-720-6/Chapter11/60-TryCatch-LocalVariable.sql 1-59059-720-6/Chapter11/7-Full-OUTERJOIN.sql 1-59059-720-6/Chapter11/8-CROSS-JOIN.sql 1-59059-720-6/Chapter11/9-Variables.sql 1-59059-720-6/Chapter11/readme.txt 1-59059-720-6/Chapter12/ 1-59059-720-6/Chapter12/1-MaxSharePriceExample.sql 1-59059-720-6/Chapter12/10-CTE-NoCTE.sql 1-59059-720-6/Chapter12/11-CTE-WithCTE.sql 1-59059-720-6/Chapter12/12-Recursive-CTE.sql 1-59059-720-6/Chapter12/13-Pre-PIVOT.sql 1-59059-720-6/Chapter12/14-PIVOT.sql 1-59059-720-6/Chapter12/15-UNPIVOT-Into-TEMP.sql 1-59059-720-6/Chapter12/16-ROW_NUMBER.sql 1-59059-720-6/Chapter12/17-RowNum-2.sql 1-59059-720-6/Chapter12/18-Rank.sql 1-59059-720-6/Chapter12/19-DenseRank.sql 1-59059-720-6/Chapter12/2-Correlated-Subquery.sql 1-59059-720-6/Chapter12/20-NTile.sql 1-59059-720-6/Chapter12/21-sp_tableoption.sql 1-59059-720-6/Chapter12/22-LOB-1.sql 1-59059-720-6/Chapter12/23-LOB-Select.sql 1-59059-720-6/Chapter12/24-LOB-Update-Dolphins.sql 1-59059-720-6/Chapter12/25-Update-Raiders.sql 1-59059-720-6/Chapter12/26-Select-Raiders.sql 1-59059-720-6/Chapter12/27-Image-LOB.sql 1-59059-720-6/Chapter12/28-UpdateImage.sql 1-59059-720-6/Chapter12/3-Backup-ReferenceONLY.sql 1-59059-720-6/Chapter12/4-IN.sql 1-59059-720-6/Chapter12/5-IN-Subquery.sql 1-59059-720-6/Chapter12/6-IN-OR.sql 1-59059-720-6/Chapter12/7-NOT-EXISTS.sql 1-59059-720-6/Chapter12/8-CROSS-APPLY.sql 1-59059-720-6/Chapter12/9-OUTER-APPLY.sql 1-59059-720-6/Chapter12/readme.txt 1-59059-720-6/Chapter13/ 1-59059-720-6/Chapter13/1-Create Trigger.sql 1-59059-720-6/Chapter13/10-Test-AlterUpdate.sql 1-59059-720-6/Chapter13/12-COLUMNS-UPDATED.sql 1-59059-720-6/Chapter13/13-DDL Trigger.sql 1-59059-720-6/Chapter13/14-Test-DDL-Trigger.sql 1-59059-720-6/Chapter13/15-Drop-DDL-Trigger.sql 1-59059-720-6/Chapter13/16-CreateSecondDDLTrigger.sql 1-59059-720-6/Chapter13/17-Test-DDL-2.sql 1-59059-720-6/Chapter13/2-Test Trigger.sql 1-59059-720-6/Chapter13/3-Noncash Test.sql 1-59059-720-6/Chapter13/4-InspectingTransactionDetails.sql 1-59059-720-6/Chapter13/5-AlterTrigger.sql 1-59059-720-6/Chapter13/6-NonCash-Retest.sql 1-59059-720-6/Chapter13/7-UPDATE-Trigger.sql 1-59059-720-6/Chapter13/8-Test-UPDATE.sql 1-59059-720-6/Chapter13/9-AlterUPDATE.sql 1-59059-720-6/Chapter14/ 1-59059-720-6/Chapter14/1-ReportStructure.sql