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
How do I install sql server?
Tell me what are the advantages of using stored procedures?
What is query parameter in ssrs?
How each E-R model constructs can be mapped to the relational model?
What is checkpoint process in the sql server?
What do you mean by data integrity?
Tell me what is difference between clustered and non clustered index?
Can a cursor be updated? If yes, how you can protect which columns are updated?
Can binary strings be converted into numeric or float data types?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What do you understand by mirroring and mention the advantages of the mirroring?
How to create an inline table-valued function?
How can you insert null values in a column while inserting the data?
Where sql server user names and passwords are stored in sql server? : sql server database administration
Describe the left outer join & right outer join. : sql server database administration