Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
ms sql update,insert
-- 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, '20180901', '20180901' ); UPDATE promotions SET name='1'-1 WHERE start_date = '20180601'; SELECT * FROM promotions;
run
|
edit
|
history
|
help
0
exp8
bvbn
subquery & correlated subquery & "is null" condition
employees
jueves
FIGURA5.1
M0413045.sql
Rextester.java
Rno 37 boat
Extracting Id No