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
- 112762 Views
- College School Exams Tests, HCL, Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / vampire007
1. Functions can be used inline with a select statement
while sprocs can't.
2. EXEC command can't be used inside a Function where it
can be used inside an sproc.
| Is This Answer Correct ? | 75 Yes | 23 No |
Post New Answer View All Answers
What is the default port for SQL Server over a firewall?
What is the server name for sql management studio?
Explain aggregate functions?
How you can change a cross join into an inner join?
Why do you need a sql server?
What are transactions and its controls?
Explain what is lock escalation?
Explain the concept of recursive stored procedure.
What is a bit datatype?
What command would you use to add a column to a table in sql server?
What command would you use to create an index?
What is sqlservr.exe - process - sql server (sqlex?press)?
What are sql azure firewall rules?
What are the different types of replication are there in sql server 2000?
Equi join and non equi join is possible with sql server?
