Sign Up Login


  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 triggers in ms sql server?

0 Answers  

How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?

1 Answers  

What do you understand by the data quality services in sql server?

0 Answers  

If user is owning any SQL Objects, can we drop that user

0 Answers  

What is a collation?

0 Answers  




What is instead of trigger sql server?

0 Answers  

What are pessimistic lock and optimistic lock?

0 Answers  

Explain the categories of stored procedure?

0 Answers  

What are the steps to process a single select statement?

0 Answers  

What is stored in the mssqlsystemresource database? : sql server database administration

0 Answers  

What is the use of RDBMS?

0 Answers   Wipro,

How can you see what type of locks used?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories