insert into value null code example

Example 1: sql insert record with null values

INSERT INTO agents
VALUES ("A001","Jodi","London",.12,NULL);

Example 2: value is null to insert in c#

PreparedCommand += "( " + info[0] + ",'" + info[1] + "'," + (item2.Value == null ? "'NULL'" : "'"+item2.Value+"'") + "),";