文件名称:Beginning_SQL_Server_2005_Express_for_Developers_F

  • 所属分类:
  • 其它资源
  • 资源属性:
  • [SQL] [源码]
  • 上传时间:
  • 2008-10-13
  • 文件大小:
  • 61.08kb
  • 下载次数:
  • 0次
  • 提 供 者:
  • Ke***
  • 相关连接:
  • 下载说明:
  • 别用迅雷下载,失败请重下,重下不扣分!

介绍说明--下载内容均来自于网络,请自行研究使用

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

相关说明

  • 本站资源为会员上传分享交流与学习,如有侵犯您的权益,请联系我们删除.
  • 本站是交换下载平台,提供交流渠道,下载内容来自于网络,除下载问题外,其它问题请自行百度更多...
  • 请直接用浏览器下载本站内容,不要使用迅雷之类的下载软件,用WinRAR最新版进行解压.
  • 如果您发现内容无法下载,请稍后再次尝试;或者到消费记录里找到下载记录反馈给我们.
  • 下载后发现下载的内容跟说明不相乎,请到消费记录里找到下载记录反馈给我们,经确认后退回积分.
  • 如下载前有疑问,可以通过点击"提供者"的名字,查看对方的联系方式,联系对方咨询.

相关评论

暂无评论内容.

发表评论

*主  题:
*内  容:
*验 证 码:

源码中国 www.ymcn.org