1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What are the types of stored procedures in an sql server?

Question Posted / suchita kumari


What are the types of stored procedures in an sql server?..

Answer / Kush Gandhi

"There are two types of stored procedures in SQL Server: Scalar-valued functions (returns a single value) and Table-valued functions (returns a table or result set)."n

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is live lock and deadlock? what is Lock escalation?

2 Answers   Microsoft,

Is it true, that there is no difference between a rule and a check constraint?

1 Answers  

What are the advantages of user-defined functions over stored procedures in sql server?

1 Answers  

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1 Answers  

Explain about service Broker functions?

1 Answers  

What is normalization and its forms?

4 Answers   Challenger Financial,

What is a linked server in sql server?

1 Answers  

What is page-level compression?

1 Answers  

Explain the categories of stored procedure?

1 Answers  

What is explicit mode in sql server?

1 Answers  

What are date and time data types in ms sql server?

1 Answers  

What is the new security features added in sql server 2016? : sql server security

1 Answers  

For more SQL Server Interview Questions Click Here
Categories