Tag: dynamic sql

10 SP_EXECUTESQL Gotchas to Avoid for Better Dynamic SQL

SQL Server • One Comment

Do you know how powerful a tool like dynamic SQL can be? Use it the wrong way, and you can allow...
Read More

Execute Dynamic Query in SQL Server

Database development, Statements, Stored Procedures

Dynamic SQL is a statement constructed and executed at runtime, usually containing dynamically generated SQL string parts, input...
Read More

Dynamic SQL vs Stored Procedure

SQL Server

Dynamic SQL and stored procedures are among the most important SQL Server components. Both have advantages and disadvantages. That’s...
Read More

Pitfalls of Linked Server Usage

Computer Environment, Languages & Coding

An interesting project related to the task queue processing come to the company I work for. It was...
Read More

Dynamic T-SQL and Benefits of its Usage

Languages & Coding, T-SQL

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...
Read More

How to Pass Parameters in Dynamic T-SQL Query

Languages & Coding, T-SQL

Developers are often faced with the need to build a dynamic query, however, there are a number of pitfalls, which we will discuss further...
Read More
Close