What is user stored procedure & it purpose?

Answer Posted / hari

Stored procedure is nothing but a Set of T-Sql statements
combined to perform a single task of several tasks. it's
like a macro

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you know spatial data types - geometry and geography in sql server 2008?

768


Explain following error properties?

731


How many databases instances are there in sql server 2000?

755


What security features are available for stored procedure?

765


what is checksum in sql server.........???

1376






Explain optimistic and pessimistic concurrency?

724


How do you start single user mode in clustered installations?

709


What does the on delete cascade option do?

747


What is a data collection table?

725


List few advantages of stored procedure.

725


Can we shrink data file in sql server?

758


How to use union to merge outputs from two queries together in ms sql server?

751


Why we use functions in sql server?

719


What is RMS migrations?

1886


Why I can not enter 0.001 second in date and time literals in ms sql server?

749