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,
Answer Posted / satish
Use Trigger to check the values cuming .. :)
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to list all user names in a database?
How to test a dml trigger in ms sql server?
What are the different sql server versions?
What are the steps you should follow to start sql server in single-user mode?
what are constraints? Explain different types of constraints? : Sql server database administration
What's the information that can be stored inside a bit column?
Can you explain what is indexed view? How to create it?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
How would you use user_constraints table in DB?
What are the different types of stored procedures?
Explain indexed views?
What are a database and a data warehouse?
Is the primary key column of a table an index in ms sql server?
What is BCNF? How is it better than 2NF & 3NF?
OPTIMIZATION OF SP,CURSOR,TRIGGERS