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,

2 Answers  

---

What is the sql profiler?

0 Answers  

---

How do I setup a local sql server database?

0 Answers  

---

Which virtual table does a trigger use?

3 Answers  

---

What are SQL Jobs, please mention the use of it and how to create them.

1 Answers   247Customer,

---

What is difference between inner join and full join?

0 Answers  

---

If a table does not have a unique index, can a cursor be opened on it?

0 Answers  

---

Explain the new features of SQL server 2000?

1 Answers  

---

How to convert a numeric expression from one data type to another?

0 Answers  

---

what is the diffrence between Snap Shot and Transaction Replication

2 Answers   CSC,

---

Indexes are updated automatically is the full-text index also updated automatically?

0 Answers  

---

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

0 Answers  

---