What is storeprocedure?Tell me synatx for how to write stored
procedure.






What is storeprocedure?Tell me synatx for how to write stored procedure...

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

Is This Answer Correct ?    4 Yes 0 No

Post New Answer




More SQL Server Interview Questions

What do you understand by replication in sql server?

0 Answers  


Explain the properties of sub-query in sql server?

0 Answers  


What is the basic difference between clustered and a non-clustered index?

9 Answers   Infogain,


How do you load large data to the SQL server database?

2 Answers  


What is GUID in sql server?

0 Answers   BirlaSoft,






How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

0 Answers  


How to find the date and time of last updated table?

3 Answers  


What is the difference between a stored procedure and a user defined function?

0 Answers  


What is built-in/administrator?

0 Answers  


How to turn on the mssql api module in php?

0 Answers  


What is the difference between update lock and exclusive lock?

0 Answers  


what type of indexes physically sort data?

3 Answers  






Categories