Answer / 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

which one will take 1st priority in case of insert statement and select statement???

2 Answers   HCL,

---

What is the advantage of sql server?

0 Answers  

---

What are the advantages to use stored procedures?

0 Answers   Ernst Young,

---

What is indexing explain it with an example?

0 Answers  

---

Explain the creation and execution of a user-defined function in the sql server?

0 Answers  

---

---

Define self join in sql server joins?

0 Answers  

---

How to find out what is the default collation in a database?

0 Answers  

---

What is the difference between a check constraint and a rule?

0 Answers  

---

what is memory-optimized nonclustered indexes

0 Answers  

---

Explain what is row_number function?

0 Answers  

---

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

0 Answers   QuestPond,

---

How to transfer data from a cursor to variables with a "fetch" statement?

0 Answers  

---