Defensive Database Programming - Robust T-SQL Code?

Question

In application development, there is the concept of security programming. How to implement protective programming methods and write reliable code using Transact-SQL?

Answer 1

• Simple discussion ...
• ... books
• SQL Server Center
• Alexander Kuznetsov (who is a user of SO AlexKuznetsov )

Generally

• Understand TRY..CATCH and error handling
• Data type security (e.g. no comparison of numbers with nvarchar)
• Transaction understanding
• SQL-

Answer 2

, :

• TRY/CATCH, SQL Server
• RAISERROR, -
• ()

Answer 3

IF EXISTS()

- , T-SQL, . , SQL-, , .

Answer 4

, " DBA - " , .

Answer 5

, , !