Insert Default Value When Parameter Is Null

How to set a default value when inserting null

If you really want the column to default to a non-null value, even if the INSERT statement has NULL for it, you can use the DEFAULT ON NULL syntax, e.g.:

ALTER TABLE CUSTOMER MODIFY CUST_STATE DEFAULT ON NULL 'NOT STATED';

or, if you are creating the table from scratch:

CREATE TABLE CUSTOMER
(
CUST_ID     VARCHAR(10),
CUST_NAME   VARCHAR(20)   NOT NULL UNIQUE,
CUST_DOB    DATE          NULL,               
CUST_STATE  VARCHAR(20)   DEFAULT ON NULL 'NOT STATED',
PRIMARY KEY(CUST_ID)
);

Now, when you insert a row with NULL for that column:

INSERT INTO CUSTOMER VALUES ('C007','Gray','5/20/1999','');

The row will have 'NOT STATED' for CUST_STATE.

Note: this "NOT STATED" is known as a "magic value" and is generally considered bad practice. It would be better, if you want to show "NOT STATED" on the screen if no value was entered, to use a SQL expression such as NVL(CUST_STATE,'NOT STATED') at query time.

Dart default value not set if parameter is null

You can make a constructor use the same default if an argument is omitted or null by making the default argument null and adding logic to fall back to the desired default value for the member. Note that the construction parameter will be nullable, but the member does not need to be. For example:

class TargetField {
  FieldType fieldType;
  final String fieldName;

  TargetField({required this.fieldName, FieldType? fieldType})
    : fieldType = fieldType ?? FieldType.string;

This technique is also useful for using non-const values as default arguments.

Inserting DEFAULT value into a column when a parameter is NULL

As param_2 can only be one of null or not null only one of the selects will return a row to be inserted:

with i as (
    insert into my_table (val_1)
    select param_1
    where param_2 is null
)
insert into my_table (val_1, val_2)
select param_1, param_2
where param_2 is not null

If it is necessary to return the inserted values:

with i_null as (
    insert into my_table (val_1)
    select param_1
    where param_2 is null
    returning *
), i_notnull as (
    insert into my_table (val_1, val_2)
    select param_1, param_2
    where param_2 is not null
    returning *
)
select * from i_null
union all
select * from i_notnull

How to set the default value for INT parameter to NULL?

Use condition as ([fkDepartment] IS NULL AND @departmentID IS NULL) OR [fkDepartment] = @departmentID

DECLARE @departmentID INT = NULL

SELECT
[strEmployeeName]
FROM
tblEmployees
WHERE ([fkDepartment] IS NULL AND @departmentID IS NULL) OR [fkDepartment] = @departmentID

Is there way to set default as null for SQL parameter?

You must include the addValue(ACCOUNT_ID, null) and addValue(USER_ID, null) because your INSERT statement includes the two named parameters :account_id, :user_id.

The framework attempts to extract the values for the named parameters from the MapSqlParameterSource object and when it does not find one of them, it throws the exception. It does this to avoid user errors, because if you didn't intend to provide a value for a parameter, you wouldn't include the parameter in the INSERT statement.

Sending default parameter as null and use default value set in function

When you start the value parameters happens:

 function makecoffee($type = "cappuccino")
    {
        return "Making a cup of $type.\n";
    }
    echo makecoffee();
    echo makecoffee(null);
    echo makecoffee("espresso");
    ?>

The above example will output:

Making a cup of cappuccino.
Making a cup of .
Making a cup of espresso.

To fulfill what you want to check with conditions as follows:

function test($username, $is_active=1, $sent_email=1, $sent_sms=1) {

    if($sent_email!=1)
        $sent_email=1;
      echo $sent_email;  // It should print default ie 1

    }