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...

  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 output for this query select * from employee where 1=1;

4 Answers  

How to get the count of distinct records. Please give me the query?

8 Answers   Value Labs,

What are the components of dbms?

0 Answers  

Does sql server 2016 have ssms?

0 Answers  

Can two different columns be merged into single column? Show practically?

0 Answers   QuestPond,

Hi, I have a table A which has four rows as follows Table A ------- empname salary ------- ------ A 1000 B 2000 C 3000 A 1000 B 2000 D 5000 I need the following output: empname salary ------- ------ A 1000 A 1000 B 2000 B 2000 Thanks in advance

10 Answers   IBM,

How do I get to sql server configuration manager?

0 Answers  

How do you use DBCC statements to monitor various aspects of a SQL server installation?

1 Answers  

Explain the steps to create and execute a user-defined function in the sql server?

0 Answers  

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

0 Answers  

What is abstracting periodical?

0 Answers  

what's the maximum size of a row? : Sql server database administration

0 Answers  

For more SQL Server Interview Questions Click Here
Categories