sql insert data into column code example

Example 1: sql add column bit

ALTER TABLE person add  [AdminApproved] BIT default 'FALSE';

Example 2: how to add records to sql table

INSERT INTO Customer (FirstName, LastName, City, Country, Phone)
VALUES ('Craig', 'Smith', 'New York', 'USA', 1-01-993 2800)

Example 3: sql insert into

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

Example 4: how to insert data in sql

//to insert value
INSERT INTO students VALUES (200, 'Jones', 101);
INSERT INTO students VALUES (201, 'Smith', 101);
INSERT INTO students VALUE (202, 'Lee' , 102);