use DML triggers which helps u to prevent any modifications.

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 / murtaza

2 Answers
5079 Views
I also Faced
E-Mail Answers

Answer Posted / murtaza

use DML triggers which helps u to prevent any modifications.

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

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

1061

Which data type columns are the best candidates for full-text indexing?

955

Will the writetext statement activate a trigger?

1063

What is the difference between count and distinct count?

869

What is named calculation? : sql server analysis services, ssas

959

How to create a simple table to test triggers in ms sql server?

962

Explain the third normal form(3nf)?

921

Where sql server usernames and passwords are stored in a sql server?

969

How to transfer an existing table from one schema to another schema in ms sql server?

964

Difference between primary key and clustered index?

981

What is difference between getdate and sysdatetime in sql server 2008?

1040

What is buffer cash in sql server?

1138

Explain activity monitors

1053

Can you explain what are commit and rollback in sql?

917

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

906