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 difference between getdate and sysdatetime in sql server 2008?

1040

---

What are “phantom rows”?

1642

---

What is your recommendation for a query running very slow? : sql server database administration

1025

---

How to automatically create a log when an exception is being received into SQL Server?

1258

---

What is perspective, have you ever created perspective? : sql server analysis services, ssas

899

---

Do you know sql server 2008 introduces automatic auditing?

957

---

How to generate create table script on an existing table in ms sql server?

1131

---

What do you mean by tablesample?

1063

---

What is b tree index?

901

---

List out a number of the wants to setup a SQL Server failover cluster?

1046

---

How can you check the level of fragmentation on a table?

1031

---

What is the purpose of the tempdb database?

983

---

What is cursor in ms sql server?

1124

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

1030

---

Is candidate a key?

930

---