Azure Microsoft.Sql/servers/databases 语法和属性,用于部署资源的 Azure 资源管理器模板。 API 版本 2014-04-01
使用从 SQL Server 数据库检索的数据填充 ADO.NET DataSet。 更新数据库以反映对 DataSet数据所做的更改(插入、更新、删除)。本文提供了 Visual C++ .NET 代码示例,演示如何 SqlDataAdapter 使用对象通过对 DataSet 数据库中表中的数据填充的对象执行的数据修改来更新 SQL Server 数据库。
Alternatively, ActiveX script commands can be externally compiled (for example, using Microsoft Visual Basic) and then run as executable programs.When a job step command is an ActiveX script, you can use the SQLActiveScriptHost object to print output to the job step history log or create COM ...
Applies to: SQL ServerGet started using SQL Server Management Studio (SSMS) to connect to your SQL Server instance and run some Transact-SQL (T-SQL) commands.Note While Microsoft Entra ID is the new name for Azure Active Directory (Azure AD), to prevent disrupting existing environments, Azure...
Connect to a SQL Server instance Create a database Create a table 显示另外 4 个 Applies to:SQL Server Get started using SQL Server Management Studio (SSMS) to connect to your SQL Server instance and run some Transact-SQL (T-SQL) commands. ...
Initiates the asynchronous execution of the Transact-SQL statement or stored procedure that is described by this SqlCommand, and retrieves one or more result sets from the server.
You use the Transact-SQL BULK INSERT statement, or the OPENROWSET(BULK) function, or you use one of the Bulk Insert API commands such as .NET SqlBulkCopy, OLEDB Fast Load APIs, or the ODBC Bulk Copy APIs to bulk copy data into a table. The TABLOCK hint is specified or the table...
Executes a command string or character string within a Transact-SQL batch, or one of the following modules: system stored procedure, user-defined stored procedure, CLR stored procedure, scalar-valued user-defined function, or extended stored procedure. The EXEC or EXECUTE statement can be used to...
Applies to: SQL Server Azure SQL Managed Instance Troubleshooting replication errors can be frustrating without a basic understanding of how transactional replication works. The first step in creating a publication is having the Snapshot Agent create the snapshot and save it to the snapshot folder....
The rxImport function allows you to import data from fixed or delimited text files, SAS files, SPSS files, or a SQL Server, Teradata, or ODBC connection. There’s no need to have SAS or SPSS installed on your system to import those file types, but you need a locally ins...