What is storeprocedure?Tell me synatx for how to write stored
procedure.
- 1 Answers
- 4153 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
What is database replication? What are the different types of replication you can set up in sql server?
Can you create a logon trigger in sql server 2005 express edition?
How to enter comments in transact-sql statements?
What do you mean by collation recursive stored procedure?
Can I run multiple instances of sql server 2000 at the same time on one computer?
How to recompile stored procedure at run time?
what stored procedure can you use to display the current processes? : Sql server administration
What’s the distinction between dropping a info and taking a info offline?
What is ms sql server index?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
Differentiate between SQL and ORACLE joins and write their syntax.
List out some of the requirements to set up a sql server failover cluster?
What are the new features are introduced in sql server 2012 reporting services?
Can we call stored procedure in view in sql server?
1 01 101 01010
