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
Answer / murtaza
use DML triggers which helps u to prevent any modifications.
| Is This Answer Correct ? | 2 Yes | 1 No |
How do I open port 1433?
What is full outer join in sql server joins?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
What types of replication are supported in sql server?
how to implement locking in sql server
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
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,
How do I view a procedure in sql server?
What happens if ntwdblib.dll is missing on your machine?
what is Covering Index ?
sql server architecture ?
How do you find the error, how can you know the number of rows effected by last SQL statement?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)