Interested to Buy Any Domain ? << Click Here >> for more details...
What is storeprocedure?Tell me synatx for how to write stored
procedure.
- 1 Answers
- 5085 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 filestream?
What are the types of subquery?
Why do we use functions?
can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?
what is denormalization? : Sql server database administration
How do I open port 1433?
Is a primary key unique?
how to know description of a table in sqlserver 2000
What are distributed partitioned views?
Comment,Datatypes are unlimited
What is a view and what are its advantages?
If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?
-
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)
