Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
SUPPLIER
CREATE TABLE SUPPLIER( supplier_id VARCHAR(5) PRIMARY KEY, supplier_name VARCHAR(20) NOT NULL, address VARCHAR(30), email VARCHAR(30), phone_number CHAR(12), ); INSERT INTO SUPPLIER VALUES ('c234', 'john carten', '59 sandmere avenue','johncarten@gmail.com', '3658887458'); INSERT INTO SUPPLIER VALUES ('c456', 'dean ambros', '45 brookland blvd', 'deanambros@gmail.com', '7854445695 '); INSERT INTO SUPPLIER VALUES ('c231', 'roman regins', '221 autum blvd', 'romanregin@gmail.com', '1236987542'); INSERT INTO SUPPLIER VALUES ('c599', 'seth rollins','54 sandalwood avenue', 'sethrollins@gmail.com', ' 7895462185'); INSERT INTO SUPPLIER VALUES ('c221', 'brock lenser', '67 springforest square', 'brocklenser@gmail.com', ' 4569875698'); INSERT INTO SUPPLIER VALUES ('c445', 'rock smith', '23 yorkland blvd', 'rocksmith@gmail.com', '4569875212 '); INSERT INTO SUPPLIER VALUES ('c238', 'william shakes', '64 sandmere avenue', 'williamshakes@gmail.com', '9815672593 '); INSERT INTO SUPPLIER VALUES ('c220', 'chrestler', '67 springforest square', 'chrestler@gmail.com', '4569875698 '); INSERT INTO SUPPLIER VALUES ('c554', 'james collins', '90 sandalwood avenue', 'jamescollins@gmail.com', '8283039555 '); INSERT INTO SUPPLIER VALUES ('c111', 'jean ambros', '89 brookland blvd', 'jeanambros@gmail.com', ' 7854445095'); SELECT * FROM SUPPLIER;
run
|
edit
|
history
|
help
0
non_numeric_table
Digital Innovation One - SQL Server _2
№5
bdLojaRoupas
Microsoft SQL Server in 10 mn - Lesson 14 Joining Tables samples...
Trim numbers
transaction in sql server
yoo
Lab 4
Turn comma-separated numbers in string into rows