What do we consider as a dynamic sql operator?

Question

a) What do we consider as a dynamic sql operator?
 Any SQL query that dynamically adds statement (s) or even part of a statement to an SQL string?

b) Arent then parameterized strings that use placeholders for dynamically supplied values ​​are also considered dynamic sql statements?

thank

Answer 1

Dynamic SQL statements usually refer to those created using string concatenation.

"SELECT name FROM names WHERE id=" + this.id;
"SELECT name FROM names WHERE id=" + this.id + " AND age=" this.age;

, . , . WHERE.

, . , where , .

SQL-, SQL.

Answer 2

SQL - , . . , SQL, .

Answer 3

, , EXEC (@sql) EXEC sp_ExecuteSQL @sql, ... (.. ), , , , SQL, ( /), .

, , , "" (, LINQ-SQL ), , , ; -p

Answer 4

sql sql, . " " . sql

Answer 5

. , SQL.

. , / DB .

Answer 6

b) (, , ).

Answer 7

, , , Dynamic SQL vs. say, ...

... , SQL- , ..

SQL ( , ) ( ..). [ : , SQL , , , ( , , , "WITH RECOMPILE" )]

, , a), b) SQL, b) SQL. . SQL , , .

... SQL- SQL, SQL, , ) ) .
SQL , SQL-. , SQL , "SQL-side", ( SQL-, , )...
, , , , "" (, , per se), , T-SQL .. SQL , "Data-side", , .

Answer 8

, SQL , , . " ", , ORDER BY, WHERE, ..

Answer 9

a) sql? sql, (-) SQL?

- / .

b) Arent , , sql?

, AKA , . (my_variable IS NULL OR ...), OR db, .

SQL , , JOIN, , . , IN, - - SQL - (CLR, , ..).