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
EXP 8 q2
Remove duplicates with in 10 min
Alquileres
Rename column name using 'sp_rename' command
Escola
employee table
Create Index On Viiew
text
Transpose group per sequence
Dividing runs by time stamp