Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
1
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' CREATE TABLE dept (dept_id INTEGER PRIMARY KEY, dname VARCHAR(20)); CREATE TABLE emp (emp_id INTEGER PRIMARY KEY, dept_id INTEGER, ename VARCHAR(15), salary NUMERIC(6,2)); ALTER TABLE emp ADD FOREIGN KEY (dept_id) REFERENCES dept; 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_arch_id INTEGER PRIMARY KEY, daname VARCHAR(20)); INSERT INTO dept_arch SELECT dept_id, dname FROM dept; UPDATE emp SET salary = salary*(1.15) WHERE ename = 'Smith'; UPDATE dept SET dname = 'RandD' where dept_id = 2; DELETE FROM emp WHERE emp_id = 1; DELETE FROM emp ; DROP TABLE emp;
run
|
edit
|
history
|
help
0
ASDF
Recursive CTE termination
20181CSE0041
performance on update using subquery versus correlated update
ankit
FERNANDA_BD_Registro_De_Estudiantes
check constraint
Exam
1
Cine latino