Interested to Buy Any Domain ? << Click Here >> for more details...
What is storeprocedure?Tell me synatx for how to write stored
procedure.
- 1 Answers
- 5061 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
Why use view instead of a table?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
Can we join two tables without primary key?
What type of locking occurs during the snapshot generation? : sql server replication
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
How do I setup a sql server database?
How to select true false based on column value in sql server?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What is the difference between migration and upgradation in sql server?
Why can there be only one clustered index and not more than one?
Why use triggers?
Relational calculus is what type of language?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
What are the hotfixes and patches in sql server?
How to create a simple stored procedure in ms sql server?
