Run Code
|
API
|
Code Wall
|
Users
|
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
Please
log in
to post a comment.
Tabela Hospedes BD
DGDFGDFG
table variables (temporary tables)
Cte recursion
Subb7
Select empID whose salary is greater than their managers
gfhrey
Studiu Individual 1
Microsoft SQL Server T-SQL in 10 mn ~ Lesson 13 Subqueries samples...
code
Please log in to post a comment.