Answer Posted / debasish

we can use having clause without group bu clause .but it
will act as where clause

What is partition, how will you implement it? : sql server analysis services, ssas

1097

---

Explain logical operators in sql server?

1180

---

How to see the event list of an existing trigger using sys.trigger_events?

1128

---

What are different replication agents and what's their purpose? : sql server replication

1052

---

What is best institute to Learn DotNET And SQL in chennai?

2219

---

What is a unique index?

970

---

What is a trigger and types of a trigger?

1025

---

How to create sub reports?

251

---

what is the difference between a primary key and a unique key? : Sql server database administration

1041

---

Explain system functions or built-in functions? What are different types of system functions?

1033

---

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1167

---

What is clr ddl trigger?

1034

---

What does set rowcount do?

958

---

How to truncate the log in sql server 2012? : sql server database administration

1344

---

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1133

---