What is the difference between Procedure and Function
Answer Posted / devanand
procedure can not return tye but fuction must a return type
| Is This Answer Correct ? | 25 Yes | 1 No |
Post New Answer View All Answers
What is the impact on other user sessions when creating indexes?
What is the size of transaction log file?
Does group by sort data?
How to use go command in "sqlcmd"?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
What are translations and its use? : sql server analysis services, ssas
What is the most common type of join?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
Explain the cursor lock types?
what are cursors? : Sql server database administration
What is the difference between Stored Procedures and triggers?
How much is a sql server license?
What is unpivot?
what is the main function of a query parameter?
What is difference between table aliases and column aliases? Do they affect performance?