Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
DDL,DQL,DML
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' --DDL Create table SQL Server CREATE TABLE product (product_id INT NOT NULL, sku CHAR (10) NOT NULL, products VARCHAR(100), price DOUBLE PRECISION, quantity SMALLINT, PRIMARY KEY (product_id) ); --DML Insert records INSERT INTO product (product_id,sku,products,price,quantity) VALUES (101,'A113M1','Mascara',17.50, 180), (102 ,'A212M2', 'Mascara', 17.50, 75),(103, 'A221NP2', 'Nail_Polish', 12.50, 65),(104,'A332NP2','Nail_Polish', 12.50, 190 ), (105,'A36LIPG', 'Lipgloss ', 15.00, 50); --DQL Retrieve data SELECT * FROM product;
run
|
edit
|
history
|
help
0
3a
ESTEFANIA
nikesh
CTE Recursive sample
sql_fb
gfhrey
base de datos dbfloreria
ASDF
Caronas
№5