Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between stored procedure and
functions in SQL Server 2000?
- 25 Answers
- 112956 Views
- College School Exams Tests, HCL, Infosys, TCS, I also Faced
- E-Mail Answers
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
can a table be moved to different filegroup? : Sql server administration
What is self contained sub query?
What are subqueries in sql server? Explain its properties.
what is the difference between a primary key and a unique key? : Sql server database administration
What is the bookmark lookup and rid lookup?
What is the use of set nocount on/off statement?
What is difference between rownum and rowid?
What are the types of database schema? : sql server analysis services, ssas
Can you pass expressions to stored procedure parameters?
Where are sql server usernames and passwords stored in the sql server?
What is primary key and example?
What is partition index in sql server?
What is co-related sub query?
What are unicode character string data types in ms sql server?
What is transaction server distributed transaction?
