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.

Beginner Asked on May 8, 2020 in Diyotta Studio.
Add Comment
1 Answer(s)

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.

 

RE: What is the use of Default field value in SQL Parameter and how it's work?

Expert Answered on May 18, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.