I am using SQL Server 2005, I have some select and update
statements in my query with WHERE clause
I want to prevent these queries from SQL injection attacks.
What are the steps and precautions to be taken for SQL
Injection attacks?
Does anybody have suggestions?
Thanks in advance,
Answer Posted / murtaza
use DML triggers which helps u to prevent any modifications.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What methods do you follow to protect from sql injection attack?
What is proper subset of candidate key?
What is the purpose of data source?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
How to send email from database?
Explain having clause?
How do I setup a sql server database?
Explain what is lock escalation and what is its purpose?
What are the properties of the transactions?
How to create a dynamic cursor with the dynamic option?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Why union all is faster than union?
Can you get second highest salary from the table?
which table keeps the locking information? : Sql server administration