Home » DynamicSQL

Tag: DynamicSQL

Database Projects – Working with SQLCMD variables

Database Projects – Working with SQLCMD variables

Published on January 23, 2023

When I started to explore and use Database Projects, I ran into a specific situation quite fast where I was required to use SQLCMD variables. In this blog post, I will describe what they are, how you can use SQLCMD variables in Database Projects and where this might become very useful for you. Quick Overview Use Case Description What are SQLCMD variables? Practical Example Use Case Description A couple of years ago, I was working…

T-SQL Tuesday #155: Dynamic Code

Published on October 11, 2022

T-SQL Tuesday is the brainchild of Adam Machanic (blog). Steve Jones (blog, Twitter) is currently maintaining this fantastic initiative. This month’s topic has been chosen by Steve Jones (blog, Twitter), “Where have you used Dynamic SQL for in the past?“ My Contribution In the past 10 years, I have used dynamic SQL several times in specific use cases. In this blog post, I will describe the use cases I can remember. The first time I…