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
SQL Server - Multiple Holidays Model
PROC How to store the results of a Proc in a Variable
identity
Dividing runs by time stamp
Factorial
replace string
Create Date Batches from Date Range - SQL Server
mywall
Time Difference Calculation (amended v2)
aaa