To see an example of calling a stored procedure that returns multiple result sets along with update values, see Handling complex statements.Bilješka When you make the call to the getMoreResults method of the SQLServerStatement class, the previously returned result set is implicitly closed....
Schema changes that use ALTER <OBJECT> statements. For more information, see Schema Changes on Publication Databases. The following features do not depend on the compatibility level; however, they do require the Merge Agent that is included with SQL Server 2005 and later versions. Subscribers that...
Using DDL Statements in SQL - Learn how to use DDL statements in SQL for database management, including CREATE, ALTER, and DROP commands.
With theCOLLATEclause, you can override whatever the default collation is for a comparison.COLLATEmay be used in various parts of SQL statements. Here are some examples: WithORDER BY: SELECTkFROMt1ORDERBYkCOLLATElatin1_german2_ci; WithAS: ...
When you work with data in a SQL Server database by using the Microsoft SQL Server JDBC Driver and inline SQL statements, there are different classes that you can use. Which class you use depends on the type of SQL statement that you want to run....
Using statements with SQL Statements with stored procedures Using table-valued parameters Handling complex statements Using multiple result sets Using parameter metadata Using result set metadata Transactions Understanding transactions Understanding XA transactions ...
Using a stored procedure with a return status Using a stored procedure with an update count Using table-valued parameters Handling complex statements Using multiple result sets Using parameter metadata Using result set metadata Transactions Understanding row locking ...
Scenario 4: Multiple StoreFront server groups and a dedicated Microsoft SQL server instance in each data center per server group Note: This is an advanced configuration. Only attempt it if you are an experienced SQL server administrator familiar with transaction replication, and you have ...
Applications that share aSqlConnectioninstance between multiple users may want to useSqlCommand.RegisterColumnEncryptionKeyStoreProvidersOnCommand. Each user must register a key store provider on aSqlCommandinstance before executing a query to access an encrypted column. If the key store provider is able...
An executable part, with statements that assign values, control execution, and manipulate Oracle data. An optional exception-handling part, which deals with runtime error conditions. Example 8-1 Simple PL/SQL Procedure The following example shows a string-manipulation procedure that accepts both input...