What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

11 Answers   World Tech, Yardi Software,

---

What are the different type of replication in sql server?

0 Answers  

---

What are the acid properties?

0 Answers  

---

what are default? Is there a column to which a default cant be bound?

1 Answers  

---

Explain alternate key, candidate key and composite key in sql server?

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  

---

What do you mean by subquery?

0 Answers  

---

Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?

1 Answers  

---

What is service broker? : sql server database administration

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 a livelock?

0 Answers  

---

What is schemabinding a view?

0 Answers  

---