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
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
what authentication modes does sql server support? : Sql server database administration
what is an extended stored procedure? : Sql server database administration
What are the pre-defined functions in the sql server?
Is oracle faster than sql server?
What is the difference between composite index and covering index?
What is the process of normalising?
What is spatial and temporal data?
What are user-defined functions (udfs) in sql server?
Where do we use trace frag?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
What is a database in ms sql server?
What number aggregate functions are accessible there in sql?
What is default port number for sql server 2000?