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

What is the difference between a fill factor of 100 and 0?

536


What happens to a trigger with multiple affected rows?

532


What types of Joins are possible with Sql Server?

553


What does truncate do?

533


What are different types of join?

762






How to automatically create a log when an exception is being received into SQL Server?

743


What is a sql join?

576


You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

627


Why I am getting this error when renaming a database in ms sql server?

540


How to achieve Paging of records in SQL SERVER?

594


How to get a list all databases on the sql server?

583


How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

675


Explain what are the different index configurations a table can have?

697


Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

644


What are subqueries in sql server? Explain its properties.

548