无法在 WIndows 7 上安装 SQL Server 2014 - HRESULT 0x8007370B

2024-04-28

我不断收到以下错误:



TITLE: Microsoft SQL Server 2014 Setup
------------------------------

The following error has occurred:

An error occurred during the installation of assembly 'Microsoft.VC80.ATL,version="8.0.50727.6229",publicKeyToken="1fc8b3b9a1e18e3b",processorArchitecture="amd64",type="win32"'. Please refer to Help and Support for more information. HRESULT: 0x8007370B. 

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName;=Microsoft%20SQL%20Server&EvtSrc;=setup.rll&EvtID;=50000&ProdVer;=12.0.2000.8&EvtType;=0xDF039760%25401201%25401

------------------------------
BUTTONS:

OK
------------------------------
  

然后出现以下错误:

除了那些正在寻找“系统更新准备情况”的人之外,谷歌搜索 HRESULT 8007370B 不会产生太多结果。

我运行了多个“注册表修复”程序;sfc /SCANNOW给我错误“Windows 资源保护无法执行请求的操作”。

有人有主意吗?

这是日志文件:




    Overall summary:
      Final result:                  Failed: see details below
      Exit code (Decimal):           -2068052081
      Start time:                    2014-12-08 14:07:24
      End time:                      2014-12-08 14:16:06
      Requested action:              Install

    Setup completed with required actions for features.
    Troubleshooting information for those features:
      Next step for Adv_SSMS:        Use the following information to resolve the error, and then try the setup process again.
      Next step for Conn:            Use the following information to resolve the error, and then try the setup process again.
      Next step for SDK:             Use the following information to resolve the error, and then try the setup process again.
      Next step for BC:              Use the following information to resolve the error, and then try the setup process again.
      Next step for SSMS:            Use the following information to resolve the error, and then try the setup process again.
      Next step for RS:              Use the following information to resolve the error, and then try the setup process again.
      Next step for SQLEngine:       Use the following information to resolve the error, and then try the setup process again.
      Next step for FullText:        Use the following information to resolve the error, and then try the setup process again.
      Next step for Replication:     Use the following information to resolve the error, and then try the setup process again.
      Next step for Browser:         Use the following information to resolve the error, and then try the setup process again.
      Next step for BOL:             Use the following information to resolve the error, and then try the setup process again.
      Next step for ComponentUpdate: Use the following information to resolve the error, and then try the setup process again.


    Machine Properties:
      Machine name:                  DHW018661
      Machine processor count:       4
      OS version:                    Windows 7
      OS service pack:               Service Pack 1
      OS region:                     United States
      OS language:                   English (United States)
      OS architecture:               x64
      Process architecture:          64 Bit
      OS clustered:                  No

    Product features discovered:
      Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered  Configured

    Package properties:
      Description:                   Microsoft SQL Server 2014 
      ProductName:                   SQL Server 2014
      Type:                          RTM
      Version:                       12
      SPLevel:                       0
      Installation location:         E:\x64\setup\
      Installation edition:          Express

    Product Update Status:
      None discovered.

    User Input Settings:
      ACTION:                        Install
      ADDCURRENTUSERASSQLADMIN:      true
      AGTSVCACCOUNT:                 NT AUTHORITY\NETWORK SERVICE
      AGTSVCPASSWORD:                *****
      AGTSVCSTARTUPTYPE:             Disabled
      ASBACKUPDIR:                   Backup
      ASCOLLATION:                   Latin1_General_CI_AS
      ASCONFIGDIR:                   Config
      ASDATADIR:                     Data
      ASLOGDIR:                      Log
      ASPROVIDERMSOLAP:              1
      ASSERVERMODE:                  MULTIDIMENSIONAL
      ASSVCACCOUNT:                  
      ASSVCPASSWORD:                 
      ASSVCSTARTUPTYPE:              Automatic
      ASSYSADMINACCOUNTS:            
      ASTEMPDIR:                     Temp
      BROWSERSVCSTARTUPTYPE:         Disabled
      CLTCTLRNAME:                   
      CLTRESULTDIR:                  
      CLTSTARTUPTYPE:                0
      CLTSVCACCOUNT:                 
      CLTSVCPASSWORD:                
      CLTWORKINGDIR:                 
      COMMFABRICENCRYPTION:          0
      COMMFABRICNETWORKLEVEL:        0
      COMMFABRICPORT:                0
      CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20141208_140724\ConfigurationFile.ini
      CTLRSTARTUPTYPE:               0
      CTLRSVCACCOUNT:                
      CTLRSVCPASSWORD:               
      CTLRUSERS:                     
      ENABLERANU:                    true
      ENU:                           true
      ERRORREPORTING:                false
      FEATURES:                      SQLENGINE, REPLICATION, FULLTEXT, RS, CONN, BC, SDK, BOL, SSMS, ADV_SSMS, LOCALDB
      FILESTREAMLEVEL:               0
      FILESTREAMSHARENAME:           
      FTSVCACCOUNT:                  NT Service\MSSQLFDLauncher$SQLEXPRESS
      FTSVCPASSWORD:                 
      HELP:                          false
      IACCEPTSQLSERVERLICENSETERMS:  true
      INDICATEPROGRESS:              false
      INSTALLSHAREDDIR:              C:\Program Files\Microsoft SQL Server\
      INSTALLSHAREDWOWDIR:           C:\Program Files (x86)\Microsoft SQL Server\
      INSTALLSQLDATADIR:             
      INSTANCEDIR:                   C:\Program Files\Microsoft SQL Server\
      INSTANCEID:                    SQLEXPRESS
      INSTANCENAME:                  SQLEXPRESS
      ISSVCACCOUNT:                  NT AUTHORITY\Network Service
      ISSVCPASSWORD:                 
      ISSVCSTARTUPTYPE:              Automatic
      MATRIXCMBRICKCOMMPORT:         0
      MATRIXCMSERVERNAME:            
      MATRIXNAME:                    
      NPENABLED:                     0
      PID:                           *****
      QUIET:                         false
      QUIETSIMPLE:                   false
      ROLE:                          AllFeatures_WithDefaults
      RSINSTALLMODE:                 DefaultNativeMode
      RSSHPINSTALLMODE:              DefaultSharePointMode
      RSSVCACCOUNT:                  NT Service\ReportServer$SQLEXPRESS
      RSSVCPASSWORD:                 
      RSSVCSTARTUPTYPE:              Automatic
      SAPWD:                         
      SECURITYMODE:                  
      SQLBACKUPDIR:                  
      SQLCOLLATION:                  Latin1_General_CI_AS
      SQLSVCACCOUNT:                 NT Service\MSSQL$SQLEXPRESS
      SQLSVCPASSWORD:                
      SQLSVCSTARTUPTYPE:             Automatic
      SQLSYSADMINACCOUNTS:           HEAD_OFFICE\clozid1
      SQLTEMPDBDIR:                  
      SQLTEMPDBLOGDIR:               
      SQLUSERDBDIR:                  
      SQLUSERDBLOGDIR:               
      SQMREPORTING:                  false
      TCPENABLED:                    0
      UIMODE:                        Normal
      UpdateEnabled:                 true
      UpdateSource:                  MU
      USEMICROSOFTUPDATE:            false
      X86:                           false

      Configuration file:            C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20141208_140724\ConfigurationFile.ini

    Detailed results:
      Feature:                       Management Tools - Complete
      Status:                        Failed: see logs for details
      Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
      Next Step:                     Use the following information to resolve the error, and then try the setup process again.
      Component name:                SQL Server Setup Support Files
      Component error code:          1935
      Component log file:            C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20141208_140724\SqlSupport_Cpu64_1.log
      Error description:             An error occurred during the installation of assembly 'Microsoft.VC80.ATL,version="8.0.50727.6229",publicKeyToken="1fc8b3b9a1e18e3b",processorArchitecture="amd64",type="win32"'. Please refer to Help and Support for more information. HRESULT: 0x8007370B.
      Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName;=Microsoft+SQL+Server&EvtSrc;=setup.rll&EvtID;=50000&ProdVer;=12.0.2000.8&EvtType;=SqlSupport.msi%40CreateShortcuts%401935%3a0x8007370B

      Feature:                       Client Tools Connectivity
      Status:                        Failed: see logs for details
      Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
      Next Step:                     Use the following information to resolve the error, and then try the setup process again.
      Component name:                SQL Server Setup Support Files
      Component error code:          1935
      Component log file:            C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20141208_140724\SqlSupport_Cpu64_1.log
      Error description:             An error occurred during the installation of assembly 'Microsoft.VC80.ATL,version="8.0.50727.6229",publicKeyToken="1fc8b3b9a1e18e3b",processorArchitecture="amd64",type="win32"'. Please refer to Help and Support for more information. HRESULT: 0x8007370B.
      Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName;=Microsoft+SQL+Server&EvtSrc;=setup.rll&EvtID;=50000&ProdVer;=12.0.2000.8&EvtType;=SqlSupport.msi%40CreateShortcuts%401935%3a0x8007370B

      Feature:                       Client Tools SDK
      Status:                        Failed: see logs for details
      Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
      Next Step:                     Use the following information to resolve the error, and then try the setup process again.
      Component name:                SQL Server Setup Support Files
      Component error code:          1935
      Component log file:            C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20141208_140724\SqlSupport_Cpu64_1.log
      Error description:             An error occurred during the installation of assembly 'Microsoft.VC80.ATL,version="8.0.50727.6229",publicKeyToken="1fc8b3b9a1e18e3b",processorArchitecture="amd64",type="win32"'. Please refer to Help and Support for more information. HRESULT: 0x8007370B.
      Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName;=Microsoft+SQL+Server&EvtSrc;=setup.rll&EvtID;=50000&ProdVer;=12.0.2000.8&EvtType;=SqlSupport.msi%40CreateShortcuts%401935%3a0x8007370B

      Feature:                       Client Tools Backwards Compatibility
      Status:                        Failed: see logs for details
      Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
      Next Step:                     Use the following information to resolve the error, and then try the setup process again.
      Component name:                SQL Server Setup Support Files
      Component error code:          1935
      Component log file:            C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20141208_140724\SqlSupport_Cpu64_1.log
      Error description:             An error occurred during the installation of assembly 'Microsoft.VC80.ATL,version="8.0.50727.6229",publicKeyToken="1fc8b3b9a1e18e3b",processorArchitecture="amd64",type="win32"'. Please refer to Help and Support for more information. HRESULT: 0x8007370B.
      Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName;=Microsoft+SQL+Server&EvtSrc;=setup.rll&EvtID;=50000&ProdVer;=12.0.2000.8&EvtType;=SqlSupport.msi%40CreateShortcuts%401935%3a0x8007370B

      Feature:                       Management Tools - Basic
      Status:                        Failed: see logs for details
      Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
      Next Step:                     Use the following information to resolve the error, and then try the setup process again.
      Component name:                SQL Server Setup Support Files
      Component error code:          1935
      Component log file:            C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20141208_140724\SqlSupport_Cpu64_1.log
      Error description:             An error occurred during the installation of assembly 'Microsoft.VC80.ATL,version="8.0.50727.6229",publicKeyToken="1fc8b3b9a1e18e3b",processorArchitecture="amd64",type="win32"'. Please refer to Help and Support for more information. HRESULT: 0x8007370B.
      Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName;=Microsoft+SQL+Server&EvtSrc;=setup.rll&EvtID;=50000&ProdVer;=12.0.2000.8&EvtType;=SqlSupport.msi%40CreateShortcuts%401935%3a0x8007370B

      Feature:                       Reporting Services - Native
      Status:                        Failed: see logs for details
      Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
      Next Step:                     Use the following information to resolve the error, and then try the setup process again.
      Component name:                SQL Server Setup Support Files
      Component error code:          1935
      Component log file:            C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20141208_140724\SqlSupport_Cpu64_1.log
      Error description:             An error occurred during the installation of assembly 'Microsoft.VC80.ATL,version="8.0.50727.6229",publicKeyToken="1fc8b3b9a1e18e3b",processorArchitecture="amd64",type="win32"'. Please refer to Help and Support for more information. HRESULT: 0x8007370B.
      Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName;=Microsoft+SQL+Server&EvtSrc;=setup.rll&EvtID;=50000&ProdVer;=12.0.2000.8&EvtType;=SqlSupport.msi%40CreateShortcuts%401935%3a0x8007370B

      Feature:                       Database Engine Services
      Status:                        Failed: see logs for details
      Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
      Next Step:                     Use the following information to resolve the error, and then try the setup process again.
      Component name:                SQL Server Setup Support Files
      Component error code:          1935
      Component log file:            C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20141208_140724\SqlSupport_Cpu64_1.log
      Error description:             An error occurred during the installation of assembly 'Microsoft.VC80.ATL,version="8.0.50727.6229",publicKeyToken="1fc8b3b9a1e18e3b",processorArchitecture="amd64",type="win32"'. Please refer to Help and Support for more information. HRESULT: 0x8007370B.
      Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName;=Microsoft+SQL+Server&EvtSrc;=setup.rll&EvtID;=50000&ProdVer;=12.0.2000.8&EvtType;=SqlSupport.msi%40CreateShortcuts%401935%3a0x8007370B

      Feature:                       Full-Text and Semantic Extractions for Search
      Status:                        Failed: see logs for details
      Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
      Next Step:                     Use the following information to resolve the error, and then try the setup process again.
      Component name:                SQL Server Setup Support Files
      Component error code:          1935
      Component log file:            C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20141208_140724\SqlSupport_Cpu64_1.log
      Error description:             An error occurred during the installation of assembly 'Microsoft.VC80.ATL,version="8.0.50727.6229",publicKeyToken="1fc8b3b9a1e18e3b",processorArchitecture="amd64",type="win32"'. Please refer to Help and Support for more information. HRESULT: 0x8007370B.
      Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName;=Microsoft+SQL+Server&EvtSrc;=setup.rll&EvtID;=50000&ProdVer;=12.0.2000.8&EvtType;=SqlSupport.msi%40CreateShortcuts%401935%3a0x8007370B

      Feature:                       SQL Server Replication
      Status:                        Failed: see logs for details
      Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
      Next Step:                     Use the following information to resolve the error, and then try the setup process again.
      Component name:                SQL Server Setup Support Files
      Component error code:          1935
      Component log file:            C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20141208_140724\SqlSupport_Cpu64_1.log
      Error description:             An error occurred during the installation of assembly 'Microsoft.VC80.ATL,version="8.0.50727.6229",publicKeyToken="1fc8b3b9a1e18e3b",processorArchitecture="amd64",type="win32"'. Please refer to Help and Support for more information. HRESULT: 0x8007370B.
      Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName;=Microsoft+SQL+Server&EvtSrc;=setup.rll&EvtID;=50000&ProdVer;=12.0.2000.8&EvtType;=SqlSupport.msi%40CreateShortcuts%401935%3a0x8007370B

      Feature:                       SQL Browser
      Status:                        Failed: see logs for details
      Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
      Next Step:                     Use the following information to resolve the error, and then try the setup process again.
      Component name:                SQL Server Setup Support Files
      Component error code:          1935
      Component log file:            C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20141208_140724\SqlSupport_Cpu64_1.log
      Error description:             An error occurred during the installation of assembly 'Microsoft.VC80.ATL,version="8.0.50727.6229",publicKeyToken="1fc8b3b9a1e18e3b",processorArchitecture="amd64",type="win32"'. Please refer to Help and Support for more information. HRESULT: 0x8007370B.
      Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName;=Microsoft+SQL+Server&EvtSrc;=setup.rll&EvtID;=50000&ProdVer;=12.0.2000.8&EvtType;=SqlSupport.msi%40CreateShortcuts%401935%3a0x8007370B

      Feature:                       Documentation Components
      Status:                        Failed: see logs for details
      Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
      Next Step:                     Use the following information to resolve the error, and then try the setup process again.
      Component name:                SQL Server Setup Support Files
      Component error code:          1935
      Component log file:            C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20141208_140724\SqlSupport_Cpu64_1.log
      Error description:             An error occurred during the installation of assembly 'Microsoft.VC80.ATL,version="8.0.50727.6229",publicKeyToken="1fc8b3b9a1e18e3b",processorArchitecture="amd64",type="win32"'. Please refer to Help and Support for more information. HRESULT: 0x8007370B.
      Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName;=Microsoft+SQL+Server&EvtSrc;=setup.rll&EvtID;=50000&ProdVer;=12.0.2000.8&EvtType;=SqlSupport.msi%40CreateShortcuts%401935%3a0x8007370B

      Feature:                       LocalDB
      Status:                        Passed

      Feature:                       Setup Support Files
      Status:                        Failed: see logs for details
      Reason for failure:            An error occurred during the setup process of the feature.
      Next Step:                     Use the following information to resolve the error, and then try the setup process again.
      Component name:                SQL Server Setup Support Files
      Component error code:          1935
      Component log file:            C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20141208_140724\SqlSupport_Cpu64_1.log
      Error description:             An error occurred during the installation of assembly 'Microsoft.VC80.ATL,version="8.0.50727.6229",publicKeyToken="1fc8b3b9a1e18e3b",processorArchitecture="amd64",type="win32"'. Please refer to Help and Support for more information. HRESULT: 0x8007370B.
      Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName;=Microsoft+SQL+Server&EvtSrc;=setup.rll&EvtID;=50000&ProdVer;=12.0.2000.8&EvtType;=SqlSupport.msi%40CreateShortcuts%401935%3a0x8007370B

    Rules with failures:

    Global rules:

    Scenario specific rules:

    Rules report file:               C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20141208_140724\SystemConfigurationCheck_Report.htm

  

编辑:我在同一台机器上安装了 2008 R2,没有任何问题。然后我尝试了 2014 年的完整安装和“升级”安装,两者都导致了上述相同的错误。


我设法解决了该问题并安装了 SQL Server 2014。

由于 C++ 更新无法安装(或者出现任何问题)VC80.ATL消息后,我回溯并寻找可以修复 Windows 更新问题的程序。

我找到了 Windows 准备工具:http://mintywhite.com/windows-7/7maintenance/trouble-installing-windows-updates-system-update-readiness-tool-windows/ http://mintywhite.com/windows-7/7maintenance/trouble-installing-windows-updates-system-update-readiness-tool-windows/

我运行了它。跑了大约20分钟。

然后我运行了 SQL Server 2014 安装,一切顺利。

谢谢大家。

本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)

无法在 WIndows 7 上安装 SQL Server 2014 - HRESULT 0x8007370B 的相关文章

  • SQL Server 将 SP_EXECUTESQL 识别为对象而不是过程名称

    我在用DBContext Database SqlQuery
  • 如何从 SQL Server 2005 备份中恢复单个表?

    我已经使用常规 SQL Server 2005 备份命令进行了备份 有没有办法只恢复单个表 而不是整个数据库 将整个数据库恢复到另一台机器 或临时数据库 然后复制表对我来说似乎是最简单的
  • 将插入与 select 语句合并

    这对我有用 MERGE Table1 AS tgt USING SELECT TOP 1 FROM Table2 SELECT itmid FROM Table3 WHERE id id as a WHERE id id AS src ON
  • SQL Server - 在设置 COLLATE Latin1_General_CS_AS 的情况下搜索不区分大小写

    家长提问 https stackoverflow com questions 50974562 sql server update to match and replace only exact words感谢 Iamdave 部分问题得到
  • 如何在 where 子句中使用别名? [复制]

    这个问题在这里已经有答案了 可能的重复 在 WHERE 子句中引用列别名 https stackoverflow com questions 8370114 referring to a column alias in a where cl
  • SQL:列出多个连接语句中的重复记录?

    你好 以下查询在连接多个表后返回所有员工 select e from dbo EMP e join dbo HREMP a on a ID e ID join dbo LOGO c on c EMPID e id join dbo LOGO
  • SQL 解析键值字符串

    我有一个像这样的逗号分隔字符串 key1 value1 key2 value2 key3 value3 key1 value1 1 key2 value2 1 key3 value3 1 我想将它解析成一个如下所示的表 Key1 Key2
  • 游标与更新

    一家公司使用 SQL Server 数据库来存储有关其客户及其业务交易的信息 您所在的城市引入了新的区号 对于前缀小于 500 的电话号码 区号 111 保持不变 前缀为 500 及以上的号码将分配区号 222 客户表中电话列中的所有电话号
  • 一组记录中某些值相同的唯一约束

    DBMS MS Sql Server 2005 标准版 我想创建一个表约束 以便只有一个记录在表的子集中具有特定值 其中行共享特定列中的值 这可能吗 Example 我的 myTable 中有一些记录 其中有一个非唯一的外键 fk1 以及一
  • 动态/条件 SQL 连接?

    我在 MSSQL 表 TableB 中有数据 其中 dbo tableB myColumn 在特定日期后更改格式 我正在做一个简单的连接到该表 Select dbo tableB theColumnINeed from dbo tableA
  • 动态SQL生成列名?

    我有一个查询 我正在尝试将行值转换为列名称 目前我正在使用SUM Case As ColumnName 声明 像这样 SELECT SKU1 SUM Case When Sku2 157 Then Quantity Else 0 End A
  • 如何重命名 SQL Server 中名称中带有方括号的内容?

    我的一张桌子上有一列 周围有方括号 Book Category 我想重命名为Book Category 我尝试了以下查询 sp rename BookPublisher Book Category Book Category COLUMN
  • VBA仅清除数据透视表缓存,但保留数据透视表结构

    如何使用VBA清除数据透视表缓存 但不破坏数据透视表结构 我的数据透视表已连接到外部数据源 SQL 源决定哪个用户应该查看数据的哪一部分 当表刷新时 源会填充该表 我想保存 Excel 文件并使用干净的数据透视表 内部没有数据 分发它 结果
  • 如何确保使用 Microsoft Sync Framework 同步成功?

    我正在使用微软同步框架 https msdn microsoft com en us sync bb736753 aspx同步两个 Microsoft SQL Server 上的表 我创建了一个测试应用程序 它每秒在远程服务器上的表中生成一
  • 增量SQL查询

    我的应用程序有一组固定的 SQL 查询 这些查询以轮询模式运行 每 10 秒一次 由于数据库的大小 gt 100 GB 和设计 超级规范化 我遇到了性能问题 每当数据库上发生更改查询结果的 CRUD 事件时 是否可以对给定查询进行增量更改
  • 如何使用 RODBC 将数据帧保存到数据库生成的主键表

    我想使用 R 脚本将数据框输入到数据库中的现有表中 并且希望数据库中的表具有顺序主键 我的问题是 RODBC 似乎不允许主键约束 这是创建我想要的表的 SQL CREATE TABLE dbo results ID INT IDENTITY
  • 如何更新 SQL Server 中 ntext 列中的 XML 字符串?

    有一个包含 2 列的 SQL 表 ID int 和值 ntext 值行中包含各种 xml 字符串 ID Value 1
  • 当没有文件可供下载时,如何避免 SSIS FTP 任务失败?

    我正在使用 SQL Server 2005 并在 SSIS 中创建 ftp 任务 有时会有文件需要通过 ftp 传输 有时则不会 如果没有文件 我不希望任务或包失败 我已将从 ftp 任务到下一个任务的箭头更改为 完成 以便包运行 我已将允
  • SQL 查询在多用户环境中返回错误值

    一段时间以来 我们在我们的一个客户站点上发现了奇怪的数据完整性问题 经过大量调查后 我们现在已将其隔离为数据库调用 如果两个用户同时调用同一个存储过程 有时一个用户会得到另一个用户的结果 我们设置了一个测试来验证这一点 并且我们有一个循环
  • SQL 查询Where Column = '' 返回表情符号字符

    好的 我有一个包含三列的表 Id Key Value 我想删除所有行Value是空的 因此 我在删除之前编写了要选择的查询 Select from Imaging ImageTag where Value 到目前为止一切都很标准 现在这是奇

随机推荐