What is storeprocedure?Tell me synatx for how to write stored
procedure.
- 1 Answers
- 4533 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to generate create function script on an existing function?
what do you understand by change data capture?
How can you check the level of fragmentation on a table?
what are isolation levels? : Sql server database administration
What command would you use to add a column to a table in sql server?
What is temporary stored procedure?
When would you use sql joins?
What is sql or structured query language?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
Explain what is the difference between union and union all?
Explain the functionalities that views support?
What is indexing explain it with an example?
How do I find the port number for sql server?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
How can we use ConnectorJ JDBC Driver with MS SQL?
