Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
ms sql 3
-- http://www.sqlservertutorial.net/sql-serve-basics/sql-server-insert/ -- http://pentestmonkey.net/cheat-sheet/sql-injection/mssql-sql-injection-cheat-sheet -- https://www.w3schools.com/sql/sql_datatypes.asp CREATE TABLE promotions ( promotion_id INT PRIMARY KEY IDENTITY (1, 1), name VARCHAR (255) NOT NULL, discount NUMERIC (3, 2) DEFAULT 0, start_date DATE NOT NULL, expired_date DATE NOT NULL ); INSERT INTO promotions ( name, discount, start_date, expired_date ) VALUES ( '2018'-1, 0.15-0, (SELECT CURRENT_TIMESTAMP), '20180901' ); UPDATE promotions SET name='1'-1 WHERE start_date = '20180601'; SELECT * FROM promotions; SELECT * FROM promotions WHERE name BETWEEN '2016'-0 AND 'z' SELECT * FROM promotions WHERE name BETWEEN ( SELECT ascii('A')-0) AND 'z' SELECT * FROM promotions WHERE name LIKE '1%' and '%'='%'; select '0'|1
run
|
edit
|
history
|
help
0
A more controllable random string generator function for SQL Server
Task_2_Final
sqript for print !00 numbers with out loop
MOVIE TIME
OUTER JOIN
Deepak
ex2
Función Borrar carácter inicial repetido
islands and gaps problem
SQL HW 1 Appline