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
- 113707 Views
- College School Exams Tests, HCL, Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / jeetu
Function can be used inside the queries but Store procedure never used inside the queries For Example Given below:
select avg(salary) from employee;// allowed here
avg(): is function
Select sp(salary) from employee // Not allowed here
sp(): is stored Procedure
Thanks
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to use column default values in insert statements in ms sql server?
Explain what are various ways to enhance the ssrs report?
How to compare the top two records using sql?
What is the Control Flow in SSIS
explain extended properties
Explain what are the database objects? : SQL Server Architecture
What is logshipping and its purpose?
How can you hide the sql server instances?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What is unique key constraint?
Does union all remove duplicates?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
How do you rename a table in sql server?
Explain difference between cross join and full outer join?
Why can there be only one clustered index and not more than one?
