What is rank function?

0 Answers  

---

How do you test your database? : sql server database administration

0 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

1 Answers  

---

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  

---

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

0 Answers  

---

---

What is awe?

0 Answers  

---

How many types of the database links?

0 Answers   MCN Solutions,

---

Explain having clause and where clause?

0 Answers  

---

Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,

---

What is stored procedures?

0 Answers  

---

What are the differences between stored procedure and functions in SQL Server 2000?

25 Answers   College School Exams Tests, HCL, Infosys, TCS,

---

Is it true, that there is no difference between a rule and a check constraint?

0 Answers  

---