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,
- 2 Answers
- 4636 Views
- I also Faced
- E-Mail Answers
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
Are all views updatable ?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
What is table valued function and scalar valued functions?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What are pessimistic lock and optimistic lock?
How network traffic be reduced by using the stored procedure?
how to determine the service pack currently installed on sql server? : Sql server database administration
Explain indexes disadvantages?
Can foreign key be duplicate?
Explain the Ways to improve the performance of a sql azure database?
How do you clear a log file?
How to access the inserted record of an event?
What command do we use to rename a db, a table and a column?
on line cluster can we make if yes tell me the procedure
