What are the differences between stored procedure and
functions in SQL Server 2000?
Answer Posted / vampire007
1. Functions can be used inline with a select statement
while sprocs can't.
2. EXEC command can't be used inside a Function where it
can be used inside an sproc.
Is This Answer Correct ? | 75 Yes | 23 No |
Post New Answer View All Answers
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
can SSRS reports Cache results?
Should you normalize audio?
What does top operator do?
What is buffer cash and log cache in sql server?
What is the syntax to execute the sys.dm_db_missing_index_details?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
What is difference between Datepart() and Datename() in SqlServer?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
What are entities and relationships?
How do you delete duplicate rows in sql server?
What is a group function explain with an example?
Define Joins?
How to drop an existing table with "drop table" statements in ms sql server?
Differentiate between SQL and ORACLE joins and write their syntax.