Microsoft SQL Server T-SQL in 10 minutes - products, Sql Server

Microsoft SQL Server T-SQL in 10 minutes - products

/*
Microsoft TSQL Crash Course
http://www.forta.com/books/0672337924/
Example table creation script and populate "products" on sql fiddle
*/
CREATE TABLE products
( prod_id    NCHAR(10)  NOT NULL,
  vend_id    INT        NOT NULL ,
  prod_name  NCHAR(255) NOT NULL ,
  prod_price MONEY      NOT NULL ,
  prod_desc  NTEXT      NULL
);
ALTER TABLE products
ADD CONSTRAINT pk_products PRIMARY KEY (prod_id);
INSERT INTO products(prod_id, vend_id, prod_name, prod_price, prod_desc)
VALUES
('ANV01', 1001, '.5 ton anvil', 5.99, '.5 ton anvil, black, complete with handy hook'),
('ANV02', 1001, '1 ton anvil', 9.99, '1 ton anvil, black, complete with handy hook and carrying case'),
('ANV03', 1001, '2 ton anvil', 14.99, '2 ton anvil, black, complete with handy hook and carrying case'),
('OL1', 1002, 'Oil can', 8.99, 'Oil can, red'),
('FU1', 1002, 'Fuses', 3.42, '1 dozen, extra long'),
('SLING', 1003, 'Sling', 4.49, 'Sling, one size fits all'),
('TNT1', 1003, 'TNT (1 stick)', 2.50, 'TNT, red, single stick'),
('TNT2', 1003, 'TNT (5 sticks)', 10, 'TNT, red, pack of 10 sticks'),
('FB', 1003, 'Bird seed', 10, 'Large bag (suitable for road runners)'),
('FC', 1003, 'Carrots', 2.50, 'Carrots (rabbit hunting season only)'),
('SAFE', 1003, 'Safe', 50, 'Safe with combination lock'),
('DTNTR', 1003, 'Detonator', 13, 'Detonator (plunger powered), fuses not included'),
('JP1000', 1005, 'JetPack 1000', 35, 'JetPack 1000, intended for single use'),
('JP2000', 1005, 'JetPack 2000', 55, 'JetPack 2000, multi-use');
SELECT	prod_name
FROM	products
;


run \| edit \| history \| help	0