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

What is an extended Stored Procedure?

1 Answers  

---

Differences between Standby Vs No recovery?

2 Answers   Wipro,

---

Define outer join in sql server joins?

0 Answers  

---

What is coalesce and check constraint in sql server?

0 Answers  

---

How to provide login information for a new odbc dsn?

0 Answers  

---

---

Explain the cursor lock types?

0 Answers  

---

Why use view instead of a table?

0 Answers  

---

How do you troubleshoot errors in a SQL Server Agent Job?

0 Answers  

---

How can you check the version of sql server?

0 Answers  

---

Write the Syntax for Cursors.

2 Answers   CarrizalSoft Technologies, HP,

---

How many ways to create table-valued functions?

0 Answers  

---

Explain about analysis services?

0 Answers  

---