What is storeprocedure?Tell me synatx for how to write stored
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
|Is This Answer Correct ?||4 Yes||0 No|
What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename>
How many types of Cursor in SQL SERVER?
How can I create a table from another table without copying any values from the old table?
1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?
How to create a user to access a database in ms sql server using "create user" statements?
What is measure group, measure? : sql server analysis services, ssas
What is the difference between substr and charindex in the sql server?
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
Can we insert data into a view?
What is table-valued sub query?
What is system stored procedures?
how to delete duplicate rows from table in sql server