Interested to Buy Any Domain ? << Click Here >> for more details...
What is storeprocedure?Tell me synatx for how to write stored
procedure.
- 1 Answers
- 5038 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 |
How do I find the port number for sql server?
What are the five major components of a dbms?
What is Online Index Rebuild Operation?
What is the difference RDBMS and Graph Database?
What is inner join in sql server joins?
how to delete duplicate rows from table
What are the advantages of passing name-value pairs as parameters?
If we use where clause in the left outer join then how the query would behave/act?
What is the difference between createstatement and preparedstatement?
Can group by and orderby be used together?
How will you monitor replication latency in transactional replication? : sql server replication
What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.
-
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)
