Defensive database programming- robust code with T-SQL?

Question

In the application development there is a concept of defensive programming. How to implement defensive programming techniques and writing robust code using Transact-SQL?

Answer 1

• Simple Talk...
• ...books
• SQL Server Central
• Alexander Kuznetsov (who is SO user AlexKuznetsov)

More generally

• Understand TRY..CATCH and error handling
• Datatype safety (no number compare against nvarchar for example)
• Understand transactions
• Consider stored procedures
• Understand SQL injection