What are the differences between stored procedure and
functions in SQL Server 2000?
Answer Posted / srinivas
Stored procedures are a set of actions already written and
stored inside the database for acheiving a particular task
where as functions are general database objects which are
used for general purpose programming
Is This Answer Correct ? | 46 Yes | 27 No |
Post New Answer View All Answers
What is the difference between push and pull subscription? : sql server replication
How do you migrate data from mssql server to azure?
What are a database and a data warehouse?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
Explain transaction server consistency?
explain declarative management framework (dmf) in sql server 2008?
How to receive returning result from a query?
Can we store videos inside the sql server table?
What are the purposes and advantages stored procedure?
How to return the date part only from a sql server datetime datatype?
Where to find ntwdblib.dll version 2000.80.194.0?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
Why should we go for stored procedures? Why not direct queries?
explain databases and sql server databases architecture? : Sql server database administration
How can you fetch alternate records from a table?