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
- 111999 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
Your table has a large character field there are queries that use this field in their search clause what should you do?
How to make a column nullable?
What is the Disadvantage of indexed sequential file.
What happens if null values are involved in datetime operations?
What is the default fill factor value?
How to create a user to access a database in ms sql server using "create user" statements?
Difference between Inner vs outer joins?
What is database mirroring?
Can sql server be linked with other servers like oracle?
Explain the different types of backups available in sql server? : sql server database administration
Explain following error properties?
How can delete duplicate records in cte in sql server?
What is the purpose of a table?
What do you understand by triggers?
What happens if null values are involved in boolean operations?
