How many types of Stored Procedures in SQL Server

Question Posted / skmdali786

4 Answers
11230 Views
Mind Tree, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How many types of Stored Procedures in SQL Server..

Answer / skmdali786

*User defined Stored Procedures
T-SQL Stored Procedure
CLR Stored Procedure

*System Stored Procedures

Is This Answer Correct ?

10 Yes

1 No

How many types of Stored Procedures in SQL Server..

Answer / krupalini

Basically two types they are-:
1.User defined stored procedure
2.System store procedure

Is This Answer Correct ?

7 Yes

0 No

How many types of Stored Procedures in SQL Server..

Answer / ganesh bisht

There are three types of stored procedure in sql server
1.user-defined Procedures
(a)Transact-SQL stored procedure
(b)CLR Stored Procedure.

2.System Stored Procedures

3.Extended Stored Procedures

Is This Answer Correct ?

2 Yes

0 No

How many types of Stored Procedures in SQL Server..

Answer / rana

There are two type of stored Procedure in Sql Server
DDl
DML

Is This Answer Correct ?

4 Yes

13 No

Post New Answer

More ASP.NET Interview Questions

what is caching,session? when & what is used mostly in which situtations, how they r implemented in real time? tell with example?

1 Answers Satyam,

What is the advantage of mvc over asp.net? : Asp.Net MVC

0 Answers

I have created a configuration setting in my web.config and have kept it at the root level. How do I prevent it from being overridden by another web.config that appears lower in the hierarchy?

0 Answers

Name the tools or API for developing or testing web api?

0 Answers

What is the differences between a primary key and a unique key in sql server?

0 Answers

How to execute a stored procedure.and how to call it form a asp page

2 Answers

Explain repository pattern in asp.net mvc? : asp.net mvc

0 Answers

What is the use of The Page.Master Property?

1 Answers

How many types of session state management options available in asp.net?