What is storeprocedure?Tell me synatx for how to write stored
procedure.
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 happens to a trigger with multiple affected rows?
Define compound operators?
How do I setup a sql server database?
What does indexation mean?
What is normalization and its types?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
what are user defined datatypes and when you should go for them? : Sql server database administration
Can we take the full database backup in log shipping?
Why it is recommended to avoid referencing a floating point column in the where clause?
Do you know what are acid properties of transaction?
What is indexing explain it with an example?
What is lookup override?
How do you rebuild an identity column?
Equi join and non equi join is possible with sql server?
What is the difference between grant and with grant while giving permissions to the user?