Run Code
|
API
|
Code Wall
|
Users
|
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
Please
log in
to post a comment.
Uzd
SQL_Joins_Intersect_Except_Union
Teset
How to add namespace to sql generated XML output
bc160401693
megha
Shruti
Veterinary 1
Insert With Output Cluase
Libros
Please log in to post a comment.