Difference between Function and Stored Procedure?
Answer Posted / sumesh.tc
stored procedure is precompiled one but Function not( want
to compile each time)
| Is This Answer Correct ? | 20 Yes | 5 No |
Post New Answer View All Answers
Why we should not use triggers?
How many primary keys are possible in a table?
What is executereader?
How to name query output columns in ms sql server?
What is the syntax to execute the sys.dm_db_missing_index_details?
What is difference between count (*) and count 1?
What are the triggers in sql?
What is the purpose of indexing?
What does this statement do @@rowcount?
What is the purpose of object explorer and its features? : sql server management studio
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
Give me any three differences between Truncate and Delete.
Describe different Processing Modes offered by SSRS?
What is resource governor?
what are the different stages of Report Processing?