Interested to Buy Any Domain ? << Click Here >> for more details...
What is storeprocedure?Tell me synatx for how to write stored
procedure.
- 1 Answers
- 4979 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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)
as
begin
| Is This Answer Correct ? | 4 Yes | 0 No |
Can we update data in a view?
How to loop through the result set with @@fetch_status?
What is a functions and types in sql server?
How can you find out which stored procedures are recompiling?
what does the automatic recovery do? : Sql server administration
Explain “@@rowcount” and “@@error” in sql server?
What are the transaction properties?
Does partitioning improve performance?
How do I setup a local sql server database?
How to create an inline table-valued function?
Do you know how to implement service broker?
How to generate random numbers with the rand() function in ms sql server?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
