This sample provides a Transact-SQL script to create a graph database with nodes and edges and then use the new MATCH clause to match some patterns and traverse through the graph. This sample script works on both Azure SQL Database and SQL Server 2017 (14.x) and later versions. ...
Applies to: SQL Server 2017 (14.x) and later versions Azure SQL Database Azure SQL Managed Instance SQL database in Microsoft Fabric This sample provides a Transact-SQL script to create a graph database with nodes and edges and then use the new MATCH clause to match some patterns and trav...
Connect to the target database with a privileged user. Run thehr_install.sqlscript and provide inputs for the prompts. cdhuman_resources sql<system>@<connect_string>@hr_install.sql 3. Uninstalling the Sample Schemas Navigate to the sample schema folder that you want to uninstall and run the...
Execute thesakila-schema.sqlscript to create the database structure, and execute thesakila-data.sqlscript to populate the database structure, by using the following commands: mysql>SOURCEC:/temp/sakila-db/sakila-schema.sql;mysql>SOURCEC:/temp/sakila-db/sakila-data.sql; ...
This sample enables the user to generate the correspondingt-sqlscript for the source databasesqlcommand provided as input. In theconvert-sql-statementcommand the user has to mandatorily change the variable value (referVariableValueFileSample.xml) in thecontextattribute to the database name that is ...
Example T-SQL script: SQL RESTOREDATABASE[AdventureWorks2022]FROMDISK = N'C:\temp\AdventureWorks2022.bak'WITHFILE=1,MOVEN'AdventureWorks2022_Data'TON'h:\DATA\AdventureWorks2022_Data.mdf',MOVEN'AdventureWorks2022_Log'TON'i:\DATA\AdventureWorks2022_log.ldf',MOVEN'AdventureWorks2022_mod'TON'h:\data\...
Example T-SQL script: sql RESTOREDATABASE[AdventureWorks2022]FROMDISK = N'C:\temp\AdventureWorks2022.bak'WITHFILE=1,MOVEN'AdventureWorks2022_Data'TON'h:\DATA\AdventureWorks2022_Data.mdf',MOVEN'AdventureWorks2022_Log'TON'i:\DATA\AdventureWorks2022_log.ldf',MOVEN'AdventureWorks2022_mod'TON'h:\data\...
A.1.2.1 altpart.sql Script The altpart.sql script file shows how to use dynamic SQL in a PL/SQL procedure to modify all partitions of a Spatial Cartridge partitioned table. The Spatial Cartridge data dictionary view used in this SQL script requires that a registered Spatial Cartridge partitio...
DataDirect Connect offers ADO.NET managed code data providers for Db2, Oracle, Sybase, and SQL Server. TRY NOW How to create sample tables in SQL ServerMany of the samples in this tutorial use the emp and dept tables. You can create these tables using an ISQL script or the data provider...
Sample VBA Code to pass a query through to a remote SQL Server Database Save an existing query with a new name Save attachments to SQL table Schedule Access Reports/Queries to run and output to a server Script error suppression in Access 2010 Webbrowser Control Search Results Are Highli...