What is storeprocedure?Tell me synatx for how to write stored
procedure.
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 temporal table?
Name the different type of indexes in sql?
How to call stored procedure using http soap?
Explain datetimeoffset data type in sal server 2008?
Which virtual table does a trigger use?
How data can be copied from one table to another table?
List out the difference between union and union all in sql server?
1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder
3 Answers CarrizalSoft Technologies, IBM,
What is difference between sql and sql server?
Why de-normalization required?
what are file groups?
How to create a view using data from another view?
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)