RE: What is the use of Default field value in SQL Parameter and how it’s work?
I added one sql parameter in my data flow, here i observed that one field named as Default and its value is NULL so i want to know how it works during execution.
Whenever an SQL parameter is executed, it runs the query present in it. The table which is being referred in the query returns the value accordingly if there is data present in it or if the condition given in the query is being satisfied a result is stored as the value in the SQL parameter as the value.
If there is no data is present in the table or the condition is not being satisfied then an empty result is given as a value to the SQL parameter. In those cases instead of supplying an empty or NULL value to the SQL parameter, we can provide a specific default value which will be used in case of the empty and NULL resultset.