USE [TEST] GO DROP TABLE IF EXISTS TEST_TABLE GO CREATE TABLE TEST_TABLE ( TEXT1 VARCHAR(256) NOT NULL, TEXT2 VARCHAR(256) NOT NULL, TEXT3 VARCHAR(256) NULL, DECIMAL_VALUE DECIMAL(10,2) NOT NULL, INTEGER_VALUE INTEGER NULL ) GO INSERT INTO TEST_TABLE VALUES('String 1','String 2','String 3',10.2,5) GO INSERT INTO TEST_TABLE (TEXT1,TEXT2,DECIMAL_VALUE) VALUES('String 1','String 2',10.2) GO SELECT * FROM [dbo].[TEST_TABLE] GO