大网数据广告活动
安装更新与部署

Execute SQL Statements

· 52CE 我爱测

The VBScript file WiRunSQL.vbs is provided in the Windows SDK Components for Windows Installer Developers.

The VBScript file WiRunSQL.vbs is provided in the Windows SDK Components for Windows Installer Developers. This sample shows how script is used to run SQL queries and updates against a Windows Installer database. For more information, see SQL Syntax and Examples of Database Queries Using SQL and Script.

The sample script demonstrates:

Using this sample requires the CScript.exe or WScript.exe version of Windows Script Host. To use CScript.exe to run this sample, type a command at the command prompt using the following syntax. Help is displayed if the first argument is /? or if too few arguments are specified. To redirect the output to a file, end the command line with VBS > [path to file]. The sample returns a value of 0 for success, 1 if help is invoked, and 2 if the script fails.

cscript WiRunSQL.vbs [path to database][SQL queries]

Specify the path to a Windows Installer database. Specify the SQL queries that are to be executed. Note that the SQL query must be enclosed in double quotes. SELECT queries display the rows of the result list specified in the query. Binary data columns selected by a query are not displayed.

For additional scripting examples, see Windows Installer Scripting Examples. For sample utilities that do not require Windows Script Host, see Windows Installer Development Tools.

For more information, see Working with Queries and Examples of Database Queries Using SQL and Script. The sample A Localization Example demonstrates using SQL for Localizing Database Columns and Updating a Summary Information Stream.

Source: Microsoft Learn / Windows Win32 documentation by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / Windows Win32 documentation
适用范围
Windows Win32 API · Source date 05/31/2018
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。