Tag: dynamic sql

10 SP_EXECUTESQL Gotchas to Avoid for Better Dynamic SQL

12:37 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

Dynamic SQL Execution in SQL Server

09:56 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

15:53 SQL Server

Dynamic SQL and stored procedures are two of the most important components of SQL Server. In this article, we will look at the advantages...
Read More

Pitfalls of Linked Server Usage

13:44 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

11:29 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

07:56 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