Answer Posted / saket

now()

Can we use where clause in union?

1122

---

How to turn off warning messages during php execution?

1103

---

Which tcp/ip port does sql server run on? How can it be changed?

1078

---

Why we use the openxml clause?

1053

---

Do you know the cursor optimization tips?

1033

---

How is sql used in sql server?

1051

---

What is local temp table?

1018

---

What are the recovery models in sql server 2000?

997

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

1041

---

How to find tables without indexes?

1145

---

How to retrieve error messages using odbc_errormsg()?

1101

---

Explain indexed views?

1025

---

What the different components in replication and what is their use?

997

---

What is full outer join in sql server joins?

1131

---

What are the encryption mechanisms in sql server?

1076

---