What is user defined datatypes and when you should go for them?

0 Answers  

---

What are cursors? Name four types of cursors and when each one would be applied?

3 Answers   Adea Solutions,

---

What is temporal data type?

0 Answers  

---

What is named query? : sql server analysis services, ssas

0 Answers  

---

How to sort query output in descending order in ms sql server?

0 Answers  

---

---

How does clustered and non clustered index work?

0 Answers  

---

How to update multiple rows with one update statement in ms sql server?

0 Answers  

---

What is the function of inner join?

0 Answers  

---

What types of integrity are enforced by a foreign-key constraint

1 Answers  

---

Determine when to use stored procedure to complete sql server tasks?

0 Answers  

---

What is the largest component inside a field?

0 Answers  

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

0 Answers  

---