Dynamic SQL: Applications, Performance, and Security

Index

A, B, C

1. Blind SQL injection

D, E

1. Database_Log

2. Dynamic list

   1. cursor method

   2. error message

   3. execution plan

   4. ID and name

   5. IO statistics

   6. search string

   7. SQL Injection

   8. string

      1. ID

      2. literals

      3. structure

      4. using ISNULL

   9. using parameters

   10. XML creation

3. Dynamic PIVOT

   1. add color, Production.Product

   2. column list

   3. columns creation

   4. command string

   5. components

   6. financial data

   7. multiple operators

   8. products color

   9. query, Production.Product

   10. query return

   11. sale data, quarter

   12. Sub-SELECT statement

   13. variable declaration

4. Dynamic SQL

   1. advantages

   2. collation conflict error

   3. Collation_Test

   4. conditional paging

   5. considerations

   6. custom objects

      1. columns

      2. hire_date_years

      3. new data

      4. script creation

      5. TSQL view creation

   7. custom search grids

      1. command string

      2. SELECT statement

      3. stored procedure

      4. windows file explorer column chooser

   8. database

      1. backup

      2. index defragmentation ...