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 / satish

Use Trigger to check the values cuming .. :)

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a transaction and why is it important?

734


What is use of attributehierarchyenabled? : sql server analysis services, ssas

798


How do you improve the performance of a SQL Azure Database?

129


What is difference between aggregate and analytic function?

655


What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

764






optimization techinques

2390


Why truncate is ddl command?

715


What is data source object?

719


How can I create a new template for import ? : sql server management studio

791


What are sql azure firewall rules?

97


Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

752


What stored by the msdb?

773


Can sql server 2016 run on windows 7?

678


Explain the different types of joins?

743


If a stored procedure is taking a table data type, how it looks?

6091