What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

0 Answers  

---

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

0 Answers   IGT,

---

What is a trigger? Why we need it?

0 Answers   Accenture,

---

What is cursor ? And what is difference between Trigger ?

3 Answers   HCL, Polaris,

---

Explain subquery and state its properties?

0 Answers  

---

can we give the identity for existing column of the table? (already table contains 10(1-10) unique randam records)

2 Answers  

---

Can we write trigger for view?

0 Answers  

---

difference between function and procedure

3 Answers   Cognizant, HCL, TCS, Theorem,

---

Mention the differences between substr and charindex in sql server.

0 Answers  

---

What is partitioned view?

0 Answers  

---

default databases available in sql server and there uses ?

4 Answers   TCS,

---

What is trigger ?

7 Answers   Cap Gemini, SQL,

---