Answer Posted / thippeswamy.l

nd sql server 2005

How to get a list of columns in a view using "sys.columns" in ms sql server?

728

---

can you instantiate a com object by using t-sql? : Sql server database administration

716

---

What is clr ddl trigger?

731

---

How do indexes help, types?

720

---

How each E-R model constructs can be mapped to the relational model?

723

---

What are drilldown reports?

115

---

How to define output parameters in stored procedures?

713

---

List the different normalization forms?

713

---

How to write a query with a right outer join in ms sql server?

660

---

Which are ddl commands?

708

---

What is not null constraint?

815

---

What is a livelock?

722

---

How to change the ownership of a schema in ms sql server?

749

---

List out the different types of locks available in sql server?

717

---

What is the return type of executeupdate ()?

694

---