589689.xyz

[] SQL Server - Transact-SQL Basic Data Modification

  • 收录时间:2018-03-10 15:35:18
  • 文件大小:332MB
  • 下载次数:57
  • 最近下载:2021-01-21 22:08:50
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 7. Beyond the Basics/3. Demo - MERGE.wmv 18MB
  2. 3. Exploring Table Metadata/9. Demo - Catalog Views (2).wmv 13MB
  3. 6. Deleting Data/7. Demo - DELETE vs. TRUNCATE TABLE.wmv 13MB
  4. 2. Setting Up a Transact-SQL Learning Environment/6. Demo - Installing SQL Server 2012 Express with Tools.wmv 12MB
  5. 3. Exploring Table Metadata/7. Demo - Catalog Views.wmv 11MB
  6. 2. Setting Up a Transact-SQL Learning Environment/12. Demo - Attaching the AdventureWorks Sample Database.wmv 10MB
  7. 4. Inserting Data/6. Demo - Column List Usage.wmv 10MB
  8. 7. Beyond the Basics/10. Demo - Referencing Sequence Objects.wmv 10MB
  9. 4. Inserting Data/2. Demo - Backing up and restoring your sample database.wmv 9MB
  10. 4. Inserting Data/9. Demo - Transact-SQL Row Constructors.wmv 9MB
  11. 6. Deleting Data/3. Demo - Basic DELETE.wmv 9MB
  12. 7. Beyond the Basics/7. Demo - Updating Large-Value Data Types.wmv 9MB
  13. 7. Beyond the Basics/15. Demo - Batching Modifications with TOP.wmv 9MB
  14. 2. Setting Up a Transact-SQL Learning Environment/14. Demo - Execute a Data Modification Query in SSMS.wmv 8MB
  15. 4. Inserting Data/13. Demo - Populating via Derived Table and EXECUTE.wmv 8MB
  16. 5. Updating Data/13. Demo - Updating Views.wmv 8MB
  17. 5. Updating Data/11. Demo - Updating with Sub-Query Values.wmv 8MB
  18. 2. Setting Up a Transact-SQL Learning Environment/15. Demo - Execute a Data Modification Query in SSDT.wmv 8MB
  19. 7. Beyond the Basics/12. Demo - OUTPUT Clause.wmv 7MB
  20. 4. Inserting Data/11. Demo - Handling Defaults.wmv 7MB
  21. 2. Setting Up a Transact-SQL Learning Environment/8. Demo - Using SSMS.wmv 6MB
  22. 7. Beyond the Basics/5. Demo - Data Modifications with CTES.wmv 6MB
  23. 5. Updating Data/7. Demo - Handling Defaults.wmv 6MB
  24. 5. Updating Data/3. Demo - Simple UPDATE.wmv 6MB
  25. 2. Setting Up a Transact-SQL Learning Environment/10. Demo - Installing SSDT.wmv 6MB
  26. 7. Beyond the Basics/20. Demo - Error Handling.wmv 6MB
  27. 3. Exploring Table Metadata/5. Demo - sp_help.wmv 6MB
  28. 3. Exploring Table Metadata/11. Demo - Trigger Catalog View.wmv 5MB
  29. 5. Updating Data/5. Demo - UPDATE with FROM.wmv 5MB
  30. 4. Inserting Data/4. Demo - Basic Row Insert.wmv 5MB
  31. 2. Setting Up a Transact-SQL Learning Environment/4. Demo - Checking Hardware and OS Specifications.wmv 4MB
  32. 6. Deleting Data/5. Demo - WHERE and FROM clauses with DELETE.wmv 4MB
  33. 7. Beyond the Basics/17. Demo - Using Explicit Transactions.wmv 4MB
  34. 5. Updating Data/9. Demo - Compound assignment operators.wmv 4MB
  35. 2. Setting Up a Transact-SQL Learning Environment/5. Demo - Checking .NET 3.5 SP1 Prerequisites.wmv 3MB
  36. 3. Exploring Table Metadata/13. Demo - sys.dm_sql_referencing_entities.wmv 3MB
  37. 1. Introduction/1. Introduction.wmv 3MB
  38. 2. Setting Up a Transact-SQL Learning Environment/3. SQL Server 2012 Express Abridged Requirements.wmv 3MB
  39. 2. Setting Up a Transact-SQL Learning Environment/9. SQL Server Data Tools (SSDT).wmv 2MB
  40. 1. Introduction/2. Course Structure.wmv 2MB
  41. 3. Exploring Table Metadata/1. Module Introduction.wmv 2MB
  42. 7. Beyond the Basics/6. Updating Large-Value Data Types.wmv 2MB
  43. 7. Beyond the Basics/8. Minimal Logging Operations.wmv 2MB
  44. 4. Inserting Data/5. Column List.wmv 2MB
  45. 4. Inserting Data/7. Specifying Data Values.wmv 1MB
  46. 2. Setting Up a Transact-SQL Learning Environment/2. SQL Server 2012 Express with Tools.wmv 1MB
  47. 7. Beyond the Basics/1. Module Introduction.wmv 1MB
  48. 5. Updating Data/2. Simple Update.wmv 1MB
  49. 2. Setting Up a Transact-SQL Learning Environment/1. Module Introduction.wmv 1MB
  50. 7. Beyond the Basics/16. Explicit Transactions.wmv 1MB
  51. 2. Setting Up a Transact-SQL Learning Environment/7. SQL Server Management Studio (SSMS).wmv 1MB
  52. 7. Beyond the Basics/14. Batching Modifications with TOP.wmv 1MB
  53. 3. Exploring Table Metadata/8. Catalog Views (2).wmv 1MB
  54. 6. Deleting Data/6. DELETE vs. TRUNCATE TABLE.wmv 1MB
  55. 5. Updating Data/12. Updating Views.wmv 1MB
  56. 4. Inserting Data/3. Basic Row Insert.wmv 1MB
  57. 7. Beyond the Basics/2. MERGE.wmv 1MB
  58. 7. Beyond the Basics/13. Consistent Data Type Usage.wmv 1MB
  59. 3. Exploring Table Metadata/3. Identity and RowGuidCol sp_help Information.wmv 1MB
  60. 2. Setting Up a Transact-SQL Learning Environment/13. Basic Data Modification Query in SSMS and SSDT.wmv 1MB
  61. 7. Beyond the Basics/21. Course Summary.wmv 1MB
  62. 3. Exploring Table Metadata/10. Triggers.wmv 1MB
  63. 3. Exploring Table Metadata/6. Catalog Views.wmv 1MB
  64. 4. Inserting Data/12. Populating via Derived Table and EXECUTE.wmv 1MB
  65. 4. Inserting Data/1. Module Introduction.wmv 1MB
  66. 7. Beyond the Basics/9. Referencing Sequence Objects.wmv 1MB
  67. 3. Exploring Table Metadata/2. Using sp_help.wmv 994KB
  68. 2. Setting Up a Transact-SQL Learning Environment/11. AdventureWorks Sample Database.wmv 924KB
  69. 4. Inserting Data/10. Handling Defaults.wmv 918KB
  70. 3. Exploring Table Metadata/4. Constraint sp_help Information.wmv 897KB
  71. 5. Updating Data/1. Module Introduction.wmv 892KB
  72. 4. Inserting Data/8. Transact-SQL Row Constructors.wmv 889KB
  73. 6. Deleting Data/2. Basic DELETE.wmv 830KB
  74. 7. Beyond the Basics/4. Data Modifications with CTEs.wmv 815KB
  75. 5. Updating Data/4. UPDATE with FROM.wmv 795KB
  76. 6. Deleting Data/1. Module Introduction.wmv 774KB
  77. 7. Beyond the Basics/18. @@ROWCOUNT and ROWCOUNT_BIG.wmv 739KB
  78. 5. Updating Data/8. Compound assignment operators.wmv 683KB
  79. 6. Deleting Data/4. WHERE and FROM clause with DELETE.wmv 648KB
  80. 7. Beyond the Basics/19. Error Handling.wmv 616KB
  81. 3. Exploring Table Metadata/12. sys.dm_sql_referencing_entities.wmv 604KB
  82. 7. Beyond the Basics/11. OUTPUT Clause.wmv 601KB
  83. 5. Updating Data/6. Defaults.wmv 592KB
  84. 5. Updating Data/10. Updating with Sub-Query Values.wmv 369KB