Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
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
Please
log in
to post a comment.
1512081 QUAN LY DE TAI
correlated subquery & top & view & derived table & group by
SQL HW 1 Appline
search all tables for string
aa
select all tables from given schema
Task1
STACK
table creation
First Query
Please log in to post a comment.