What are the differences between stored procedure and
functions in SQL Server 2000?
Answer Posted / appu
1.we can't call stored procedure inside query instead we can call function inside query.
2.we can't use stored procedure in select statement where as we can use function in select statement.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the steps to process a single select statement?
What is bit data type? What's the information that can be stored inside a bit column?
Write a SQL query to delete a table?
explain databases and sql server databases architecture? : Sql server database administration
List types of tables in SQL Azure?
What is open database communication (odbc)?
Why would you use sql agent?
What is SubQuery in SQL Server 2008
What is the default fill factor value?
Why I am getting this error when dropping a database in ms sql server?
How do you delete duplicate records in sql server?
When do you think a developer should use sql server-based cursors?
What is transactional replication?
How to backup SQL Server Reporting Services ?
How do you migrate data from mssql server to azure?