HappyTomatoLife

SQL BACKUP DATABASE for SQL Server The SQL BACKUP DATABASE Statement SQL 데이터베이스에서 전체 백업을 만드는 명령어 Syntax BACKUP DATABASE databasename TO DISK = 'filepath'; The SQL BACKUP WITH DIFFERENTIAL Statement 변경된 부분만 백업하는 명령어 BACKUP DATABASE databasename TO DISK = 'filepath' WITH DIFFERENTIAL; BACKUP DATABASE example BACKUP DATABASE testDB TO DIST = 'D:\backups\testDB.bak'; BACKUP W..

SQL DROP DATABASE Statement The SQL DROP DATABASE Statement SQL database를 삭제하는 명령어 DROP DATABASE databasename; DROP DATABASE Example DROP DATABASE testDB;

SQL CREATE DATABASE Statement The SQL CREATE DATABASE Statement 새로운 SQL Database를 생성하는 명령어 Syntax CREATE DATABASE databasename; CREATE DATABASE Example CREATE DATABASE testDB;

SQL Operators SQL Arithmetic Operators +, -, *, /, % SQL Bitwise Operators &, |, ^ SQL Comparison Operators =, >, =,

SQL Comments 주석 Single Line Comments -- single line comments SELECT * FROM Customers; SELECT * FROM Customers --Where city='Berlin'; Multi-line Comments /* multi line comments */ SELECT * FROM Customers;

SQL Stored Procedures for SQL Server What is a Stored Procedure? 반복해서 사용할 수 있는 프로세저 Stored Procedure Syntax procedure 생성CREATE PROCEDURE procedure_name AS sql_statement GO; procedure 실행EXEC procedure_name; Stored Procedure Example CREATE PROCEDURE SelectAllCustomers AS SELECT * FROM Customers GO; EXEC SelectAllCustomers; Stored Procedure with One Parameter CREATE PROCEDURE SelectAllCustomers @Ci..

SQL NULL Functions SQL IFNULL(), ISNULL(), COALESCE(), NVL() Functions null 값을 허용하고 싶을 때 MySQL IFNULL() 이용SELECT ProductName, UnitPrice * (UnitsInStock + IFNULL(UnitsOnOrder, 0)) FROM Products; SQL server ISNULL() SELECT ProductName, UnitPrice * (UnitsInSTock + ISNULL(UnitsOnOrder, 0)) FROM Products; MS 엑세스 IsNULL() Oracle NVL()

SQL CASE Expression The SQL CASE Expression C언어의 case와 동일한 기능 CASE Syntax CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 WHEN conditionN THEN resultN ELSE result END; SQL CASE Examples SELECT OrderID, Quantity, CASE WHEN Quantity > 30 THEN 'The qunatity is greater than 30' WHEN Quantity = 30 THEN 'The quantity is 30' ELSE 'The quantity is under 30' END AS ..

SQL INSERT INTO SELECT The SQL INSERT INTO SELECT Statement 한 테이블의 데이터를 복사해서 다른 테이블에 삽입한다. 단, 이 명령문을 이용하려면 원본 테이블과 대상 테이블의 타입이 일치해야 한다. INSERT INTO SELECT Syntax INSERT INTO table2 SELECT * FROM table1 WHERE condition; INSERT INTO table2 (column1, column2, column3, ...) SELECT column1, column2, column3, ... FROM table1 WHERE condition; SQL INSERT INTO SELECT Examples INSERT INTO Customers (Custo..

SQL SELECT INTO Statement The SQL SELECT INTO Statement 한 테이블의 데이터를 다른 테이블로 복사한다. SELECT INTO Syntax SELECT * INTO newtable [IN externaldb] FROM oldtable WHERE condition; 모든 column을 다른 테이블에 복사하고 싶은 경우 SELECT column1, column2, ... INTO newtable [IN externaldb] FROM oldtable WHERE condition; 일부 column만 다른 테이블에 복사하고 싶은 경우 SQL SELECT INTO Examples SELECT * INTO CustomersBackup2017 FROM Customers; SE..