1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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,

Question Posted / vikas kant

Answers were Sorted based on User's Feedback



I am using SQL Server 2005, I have some select and update statements in my query with WHERE clause..

Answer / satish

Use Trigger to check the values cuming .. :)

Is This Answer Correct ?    4 Yes 0 No

I am using SQL Server 2005, I have some select and update statements in my query with WHERE clause..

Answer / murtaza

use DML triggers which helps u to prevent any modifications.

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What is the difference between coalesce() & isnull()?

0 Answers  

What is difference between inner join and join?

0 Answers  

How to find out the list schema name and table name for the database?

0 Answers  

how to find the second salary?

10 Answers   HCL, Prithvi,

what is the Ticketing tool used in Wipro technologies at Bangalore...???

0 Answers   Liquid Hub,




What is the boxing and unboxing concept in .net?

0 Answers  

What is buffer cash in sql server?

0 Answers  

What is the size of transaction log file?

0 Answers  

How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com

35 Answers   Oracle, Scend, TechInfini,

Can we insert data into a view?

0 Answers  

How to get number of days in a given year?

4 Answers   ADP,

Which autogrowth database setting is good?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories