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 |
Why would you use sql agent?
Explain intellisense for query editing
sql server architecture ?
Normalization and denormalization
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
Explain about integration services of Microsoft SQL server?
Write SQL queries on Self Join and Inner Join.
Explain how to send email from sql database?
Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?
What is an Index?
What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?
2 Answers Accenture, Merrill Lynch, Wipro,
What is database black box testing?
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)