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

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)

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename>

5 Answers   247Customer,

How many types of Cursor in SQL SERVER?

0 Answers  

How can I create a table from another table without copying any values from the old table?

3 Answers  

1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?

7 Answers   Microsoft,

How to create a user to access a database in ms sql server using "create user" statements?

0 Answers  

What is measure group, measure? : sql server analysis services, ssas

0 Answers  

What is the difference between substr and charindex in the sql server?

0 Answers  

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

1 Answers  

Can we insert data into a view?

0 Answers  

What is table-valued sub query?

0 Answers  

What is system stored procedures?

0 Answers  

how to delete duplicate rows from table in sql server

12 Answers   UHG, HCL,