Advantages and disadvantages of stored procedures.

Answer Posted / manoj

The only disadvantage I see with Stored-procs is that we
cannot use them with select statements.

Is This Answer Correct ?    9 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the steps to use transact-sql cursor?

523


please differentiate between delete and truncate?

557


How to drop an existing user defined function in ms sql server?

561


How to insert data into an existing table?

567


Will count(column) include columns with null values in its count?

666






What is role playing dimension with two examples? : sql server analysis services, ssas

582


what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

509


What are null values in ms sql server?

558


What is a trace frag? Where do we use it?

669


How to get the definition of a trigger back?

544


Define Wed Edition in SQL Azure?

80


What is data set in report?

95


Can I work with several databases simultaneously? : sql server management studio

555


what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

527


what is unique and xaml nonclustered index

554