Differences between functions and stored procedures?
Answer Posted / purushotam bhardwaj
FUnction use when you want to return any value only
but SP is best for all
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is bit data type?
In what three ways is the return statement used in a stored procedure?
What are the types of subquery?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What is meant by Active-Passive and Active-Active clustering setup?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
do views contain data ?
How data can be copied from one table to another table?
Explain full-text indexing?
Explain temporary table vs table variable by using cursor alternative?
Differentiate between delete and truncate.
Can an automatic recovery be initiated by a user?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
What are binary string data types in ms sql server?
Explain how to send email from sql database?