Q36. What is merge join?
Q37. What is incremental Data in sql?
Q38. What is transactional Data in sql?
Q39. What you mean by schema in sql?
Q40. What are the various return types in SQL function?
----------------------------------------------------------------------------------------------------------------------------------
Q36. What is merge join?
Answer:
----------------------------------------------------------------------------------------------------------------------------------
Q37. What is incremental Data in sql?
Answer:
----------------------------------------------------------------------------------------------------------------------------------
Q38. What is transactional Data in sql?
Answer:
----------------------------------------------------------------------------------------------------------------------------------
Q39. What you mean by schema in sql?
Answer:
----------------------------------------------------------------------------------------------------------------------------------
Q40. What are the various return types in SQL function?
Answer:
NOTE: Unlike Stored Procedure, Function returns an only single value.
User defined function can return 3 types of value
1. Scaler
2. Inline table valued - The value of the table variable should be derived from a single SELECT statement
3. Multi statement Table valued. - A user-defined multi-statement table-valued function returns a table variable as a result of actions performed by the function. In this, a table variable must be explicitly declared and defined whose value can be derived from multiple SQL statements.