What is difference between stored procedure & function?
Answer Posted / shreenath27@yahoo.co.in
function will return value but procedure will not return any
value
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
How to concatenate two strings in SQL Server.
Explain different types of self contained sub query?
How to see the event list of an existing trigger using sys.trigger_events?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
How to return the top 5 rows from a select query in ms sql server?
What are the differences between left join and inner join in sql server?
Is it possible to create trigger on views?
How to turn on the mssql api module in php?
How to use "begin ... End" statement structures in ms sql server?
Why functions are used in sql server?
How to apply filtering criteria at group level with the having clause in ms sql server?
Explain various On-Delete options in a DB table. Which is the default option?
List the different index configurations possible for a table?
What is a transactions?