SQL Server Snap Pack examples

Example Snaps used
SQL Server - Bulk Load

Load data from source table to target table

This example pipeline demonstrates how to load data from the table bulk_test_source to the table bulk_test_target with the SQL Server Bulk Load Snap.
SQL Server - Delete

Delete records from a table

This example pipeline demonstrates how to delete records from table customer_one.
SQL Server - Execute

Retrieve customer details using a SQL query

This example demonstrates how to execute a SQL query to retrieve customers with a given name from the customer1 table.
SQL Server - Insert

Insert data into a table

This example pipeline demonstrates how to insert data into a table. The customer1 table does not exist on the database initially. So, the Snap creates a table using the Create table if not present checkbox and inserts the data.
SQL Server - Lookup

Retrieve data from a table using lookup conditions

This example demonstrates how the Lookup Snap retrieves data from a table called customer1.
SQL Server - Merge

Merge data into a table

This example pipeline demonstrates how to merge data into a specific table using the SQL Server Merge Snap.
SQL Server - Update

Update data in a SQL Server database

This example pipeline demonstrates how to extract data, transform it, and update the SQL Server database.
SQL Server - Select

Fetch employee details from a table in the SQL Server database

This example pipeline demonstrates how to retrieve employee details from the Employee_Demo table.
SQL Server - Table List

Retrieve all tables from a database schema

This example demonstrates how to retrieve all the tables under schema dbo and write them to output view.
SQL Server - Stored Procedure

Execute a stored procedure to update employee records

This example demonstrates how to execute a stored procedure that updates employee data in the EMP table. The stored procedure supports the overload feature, allowing you to provide only the parameters you want to update.