Copy the Transact-SQL installation code into a file and save it as Install.sql in the sample directory. If the sample is installed in a directory other then C:\MySample\, edit the file Install.sql as indicated to point to that location. Deploy the assembly, stored procedure ...
Installing the In-Memory OLTP sample based on AdventureWorks Description of the sample tables and procedures Show 3 more Applies to: SQL Server Azure SQL Database Overview This sample showcases the In-Memory OLTP feature. It shows memory-optimized tables and natively compiled stored procedures, ...
-- The parameter name @CustomerId as expected by the stored procedure. --><ParameterName="@CustomerId"Direction="In"><!-- The IdentifierName attribute is required here. --><TypeDescriptorName="Id"TypeName="System.Int32"IdentifierName="CustomerIdentifier"/></Parameter><ParameterName="Customers...
stored-procedures-derbyProvides an example of the stored procedure Outbound Gateway usingApache Derby stored-procedures-msProvides an example of the stored procedure Outbound Gateway usingMicrosoft SQL Server stored-procedures-oracleProvides an example of the stored procedure Outbound Gateway usingORACLE XE ...
());// Connect to the database.// You can put a database name after the @ sign in the connection URL.Connection conn =DriverManager.getConnection("jdbc:oracle:oci8:@", "scott", "tiger");// line 16// Create the stored procedure.init(conn);// Prepare a PL/SQL call. line 20...
codeunit50106RewardsUpgradeCode{// An upgrade codeunit includes AL methods for synchronizing changes to a table definition// in an application with the business data table in SQL Server and migrating existing// data.Subtype = Upgrade;// "OnUpgradePerCompany" trigger is used to perform the ...
Procedure Obtain the sample project from theflink-examples-securityfolder in thesrc\flink-examplesdirectory where the sample code is decompressed. For details, seeObtaining the MRS Application Development Sample Project. You can select a sample based on the service scenario. For details about the sam...
SQL> SELECT TABLENAME FROM user_tables WHERE TABLENAME LIKE 2> '%tablename_P%'; A.1.2.2 drppart.sql Script The drppart.sql script file shows how to use dynamic SQL in a PL/SQL procedure to drop all partitions of a Spatial Cartridge partitioned table. After running this procedure, you...
Clone or download the sample from this repository, then open the solution found in root folder using your favorite IDE. Before running ensure the following dependencies are available: SQL Server is available at server=localhost;user id=sa;password=Pass@Word1; A way to accomplish it is to run...
This sample requires Microsoft SQL Server.Microsoft Visual Studio 2005 provides a RuleSet editor as part of the Windows Workflow Foundation (WF). You can start this editor by double-clicking the Policy activity in a workflow; it serializes the defined RuleSet object to the .rules file associated...