What are the differences between stored procedure and
functions in SQL Server 2000?
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
How to optimize stored procedures in sql server?
What are parameterized reports? What are cascading parameters in ssrs reports?
What is a cache in ssrs?
What are the tools available in market as an alternative to sql server reporting services?
Why do we use trigger?
What is de-normalization and what are some of the examples of it?
What are .mdf files?
how you can configure a running aggregate in SSRS?
Write SQL queries on Self Join and Inner Join.
How much memory that we are using in Logshipping Concept?
What is the importance of three tier architecture?
How to read data in a table with "select" statements?
What are the different types of sql server replication? : sql server replication
Is BCNF better than 2NF & 3NF? Why?
What are the types of table?