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

explain different types of constraints? : Sql server database administration

0 Answers  

---

Tell me what are the essential components of sql server service broker?

0 Answers  

---

Can you explain different types of locks in sql server?

0 Answers  

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

0 Answers  

---

How to write a query with a right outer join in ms sql server?

0 Answers  

---

what is replication? where do u use Go Keyword?

1 Answers   Satyam,

---

Explain view in sql server?

0 Answers  

---

what are the limitations of parameters in a storedprocedure

1 Answers  

---

what is sql injection?

2 Answers  

---

How many clustered indexes there can be on table ?

0 Answers  

---

How to manipulate data from one table to another table ?

0 Answers   MCN Solutions,

---

Can a table have 2 primary keys?

0 Answers  

---