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
Pivot unpivot
Datos relacional BRYAN
kuy09:admin09@pkms99.info
Program1
extract part of a string
Exam
join
sql
create table employees as e. No, e. Name., e. Phone no, e. Salary
BT SQL Project