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

What is a rownum?

1059

---

What are the difference between “where” and “having” clause in sql server?

1132

---

What is efficiency data?

1004

---

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

1051

---

How will you make an attribute not process? : sql server analysis services, ssas

1160

---

What is a collation?

1132

---

How can I get data from a database on another server?

1049

---

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1099

---

How to drop an existing table?

1053

---

What is key set driven?

1009

---

How do I start sql server 2017?

986

---

Can we store videos inside the sql server table?

1027

---

Explain what are magic tables in sql server?

1046

---

How do you implement session management in SQL Server mode?

1155

---

What is the full form of ddl?

970

---