10 SP_EXECUTESQL Gotchas to Avoid for Better Dynamic SQL
Do you know how powerful a tool like dynamic SQL can be? Use it the wrong way, and you can allow...
Execute Dynamic Query in SQL Server
Dynamic SQL is a statement constructed and executed at runtime, usually containing dynamically generated SQL string parts, input...
Dynamic SQL vs Stored Procedure
Dynamic SQL and stored procedures are among the most important SQL Server components. Both have advantages and disadvantages. That’s...
Pitfalls of Linked Server Usage
An interesting project related to the task queue processing come to the company I work for. It was...
Dynamic T-SQL and Benefits of its Usage
In our projects, we have to cope with different tasks. To solve some of them, we use dynamic T-SQL. Why do we need dynamic T-SQL? Well, it...
How to Pass Parameters in Dynamic T-SQL Query
Developers are often faced with the need to build a dynamic query, however, there are a number of pitfalls, which we will discuss further...
