Mega Code Archive

 

Categories / MSSQL Tutorial / Insert Delete Update

 

Eliminate the optional column list and allow SQL Server to assume were providing something for every column

3> 4> CREATE TABLE stores( 5>    stor_id        char(4)           NOT NULL, 6>    stor_name      varchar(40)           NULL, 7>    stor_address   varchar(40)           NULL, 8>    city           varchar(20)           NULL, 9>    state          char(2)               NULL, 10>    zip            char(5)               NULL 11> ) 12> GO 1> 2> 3>    INSERT INTO stores 4>    VALUES ('TEST', 'Test Store', '1234 Anywhere Street', 'Here', 'NY', '00319') 5> GO (1 rows affected) 1> 2>    INSERT INTO stores (stor_id, stor_name, city, state, zip) 3>    VALUES ('TST2', 'Test Store', 'Here', 'NY', '00319') 4> GO (1 rows affected) 1> 2>    SELECT * FROM stores WHERE stor_id = 'TST2' 3> GO stor_id stor_name                                stor_address                             city                 state zip ------- ---------------------------------------- ---------------------------------------- -------------------- ----- ----- TST2    Test Store                               NULL                                     Here                 NY    00319 (1 rows affected) 1> 2> 3> drop table stores; 4> GO