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