August 2017, SQL Simantics

Dynamic SQL – Two Ways to Make a SQL String and Run It

Randy Sims SQL Server

Dynamic SQL is just like it sounds: creating a SQL statement dynamically. A normal SQL Statement is just the string you are going to run. SELECT FIELD1, FIELD2, FIELD3 FROM TABLE1; But should you have a good business reason to do so, maybe you want to dynamically create the queries. (Personally, Dynamic SQL is the last […]

Create an SSIS Package to Import a File

Randy Sims SQL Server

This is an easy run through tutorial of how to create a SQL Server Integration Services (SSIS) package to import a file. This is the most basic task there can be for a product named “SQL Server Integration Services.” We are going to connect the database to a file so the data from the file […]