Answer Posted / sumit ranjan

Stored procedures simplify Analysis Services database development and implementation by allowing common code to be developed once and stored in a single location. Stored procedures can be used to add business functionality to your applications that is not provided by the native functionality of MDX.



create procedure myproc
@gender varchar(30)
as
begin

How to create percentile function?

139

---

What languages bi uses to achieve the goal?

947

---

List all types of constraints in sql server?

961

---

what is a join? : Sql server database administration

1125

---

What extended events?

951

---

What is the filtered index?

975

---

Explain linked server in sql?

1149

---

What are the encryption mechanisms in sql server?

968

---

What is the fastest way to permanently delete a 1 million row table named customers?

1152

---

What is sql language?

1027

---

Explain about thread and memory management process of SQL?

923

---

Can a synonym name of a table be used instead of a table name in a select statement?

973

---

Do you know nested transaction?

905

---

When would you use the stored procedures or functions?

947

---

What part does database design plays a role in performance of an sql server-based application?

926

---