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
count events by 2 shift cycles using CTE
SO 51804194 : sql-recursive-cte-replace-statement-too-slow
Manish_SQL_11_dec
Database ownership
SinghDestiny
decimal_test
bdLojaRoupas
Gangadhar
Task1
add-empty-rows-after-certain-records-in-a-table