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

Can we take the full database backup in log shipping?

0 Answers  


What is a dbms wizard?

0 Answers  


When do you create cluster and noncluster index?

5 Answers   Satyam,


user defined datatypes

1 Answers   Wipro,


What according to you is the difference between mysql and sql server performance?

0 Answers  


Explain subquery and state its properties?

0 Answers  


Explain about extended stored procedure?

0 Answers  


What is the difference between views and stored procedures? Can we have input parameters for views?

6 Answers  


How to perfor If the table running time is taking 2hours and table is having 10 rows in it?

1 Answers  


What is the difference between insensitive and scroll cursor?

0 Answers  


Define compound operators?

0 Answers  


How can we check the sql server version?

0 Answers  


Categories