What are the differences between stored procedure and
functions in SQL Server 2000?
- 25 Answers
- 106158 Views
- College School Exams Tests, HCL, Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / srinivas
Stored procedures are a set of actions already written and
stored inside the database for acheiving a particular task
where as functions are general database objects which are
used for general purpose programming
| Is This Answer Correct ? | 46 Yes | 27 No |
Post New Answer View All Answers
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Describe the functionalities that views support.
What kind of problems occurs if we do not implement proper locking strategy?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What does executeupdate return?
Explain trigger and its types?
How to test a dml trigger in ms sql server?
What methods do you follow to protect from sql injection attack?
Does windows server 2016 come with sql server?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
What are the advantages of partitioning?
How to name query output columns in ms sql server?
What is used to replicate sessions between instances in coldfusion clusters?
What are the types of database schema? : sql server analysis services, ssas
What is primary key, unique key, and foreign key?
