개발/SQL

[MSSQL] CREATE TABLE, INSERT INTO, DROP TABLE

1)CREATE TABLE 코드 예제 2)INSERT INTO 코드 예제 3)DROP TABLE 코드 예제 CREATE TABLE author( aid int not null, name varchar(20) default null primary key, city varchar(10) default null, profile_id int default null, ) INSERT INTO author values(1,'egoinh','seoul',1),(2,'leezche','jeju',2),(3,'blackdew','namhae',3); CREATE TABLE profile( pid int not null primary key, title varchar(10) default null, description ..

2022. 8. 24.

개발/SQL

[MSSQL] JOIN정리 LEFT JOIN, INNER JOIN, RIGHT JOIN 정리

--LEFT JOIUN SELECT * FROM TABLE A LEFT JOIN TABLE B ON A.ID = B.ID WHERE B.KEY IS NULL --;EFT JOIN SELECT * FROM, TABLE A LEFT JOIN TABLE B ON A.ID = B.ID --INNER JOIN SELECT * FROM TABLE A INNER JOIN TABLE B ON A. KEY = B.KEY --RIGHT JOIN SELECT * FROM TABLE A RIGHT JOIN TABLE B ON A.KEY = B.KEY WHERE A.KEY IS NULL --RIGHT JOIN SELECT * FROM TABLE A RIGHT JOIN TABLE B ON A.KEY = B.KEY --FULL O..

2022. 8. 24.