What is storeprocedure?Tell me synatx for how to write stored
procedure.
- 1 Answers
- 4517 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 |
What is the need for group functions in sql?
How to make a remote connection in a database?
Do you know how to make remote connection in database?
Can a database be shrunk to 0 bytes, if not, why?
What is raid? : SQL Server Architecture
Do you know the different ddl commands in sql?
What will you do If the low Performance occurs?
how many type of indexing in database?
How to read 2nd highest sal from EMP table?
Where are sql server user names and passwords stored in sql server?
what are file groups?
What is an entity-relationship diagram (erd)?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
