Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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,

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

Why would you use sql agent?

0 Answers  


Explain intellisense for query editing

0 Answers  


sql server architecture ?

0 Answers  


Normalization and denormalization

3 Answers   Wipro,


you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

0 Answers  


Explain about integration services of Microsoft SQL server?

0 Answers  


Write SQL queries on Self Join and Inner Join.

0 Answers   Aspiring Minds,


Explain how to send email from sql database?

0 Answers  


Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?

4 Answers  


What is an Index?

3 Answers   Yardi Software,


What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

2 Answers   Accenture, Merrill Lynch, Wipro,


What is database black box testing?

0 Answers  


Categories