Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
SQL HW 1 Appline
--Sql Server 2014 Express Edition --Batches are separated by 'go' CREATE TABLE dept( dept_id INTEGER NOT NULL PRIMARY KEY, dname VARCHAR(20) ); CREATE TABLE emp( emp_id INTEGER NOT NULL, dept_id INTEGER, FOREIGN KEY (dept_id) REFERENCES dept(dept_id), ename VARCHAR(15), salary NUMERIC(6, 2) ); INSERT INTO dept VALUES (1, 'Marketing'), (2, 'RD'); INSERT INTO emp VALUES (1, 1, 'James', 1000), (2, 2, 'Smith', 2000); CREATE TABLE dept_arch( dept_id INTEGER, dname VARCHAR(20) ); INSERT INTO dept_arch SELECT dept_id, dname FROM dept; UPDATE emp SET salary = salary+salary*0.15 WHERE ename = 'Smith'; /* INSERT INTO emp VALUES (3, 4, 'Black', 3000, 'Active'); - невыполнимая операция, т.к. у нас в таблице emp всего 4 столбца; */ /* INSERT INTO dept VALUES (2, 'Sales'); - невыполнимая операция, т.к. повторяется ключ, который уже занят (2); */ SELECT * FROM emp; SELECT * FROM dept; SELECT * FROM dept_arch;
run
|
edit
|
history
|
help
0
Cristina
get date part from datetime
add loopback linked server
ms sql where ,like
QUAN LY MAYBAY
Rno 37 boat
SQL Server - regex filtering using LIKE
SQL Server NULL replacement with dynamic value
sql_fb
sql_fb