HappyTomatoLife

SQL Constraints SQL Create Constraints create table에 붙일 수 있는 constraints CREATE TABLE table_name ( column1 datatype constraint, column2 datatype constraint, column3 datatype constraint ); SQL Constraints NOT NULL UNIQUE PRIMARY KEY FOREIGN KEY CHECK DEFAULT CREATE INDEX

SQL ALTER TABLE Statement SQL ALTER TABLE Statement 기존 테이블의 구조를 변경할 때 사용하는 명령어 ALTER - ADD, DROP, ALTER, MODIFY로 세분화된다. ALTER TABLE - ADD COLUMN ALTER TABLE table_name ADD column_name datatype; ALTER TABLE Customers ADD Email varchar(255); ALTER TABLE - DROP COLUMN ALTER TABLE table_name DROP COLUMN column_name; ALTER TABLE Customers DROP COLUMN Email; ALTER TABLE - ALTER/MODIFY COLUMN ALTER TAB..

SQL DROP TABLE Statement The SQL DROP TABLE Statement 테이블을 삭제 DROP TABLE table_name; SQL DROP TABLE Example DROP TABLE Shippers; SQL TRUNCATE TABLE 테이블 내부의 데이터를 삭제, 테이블 자체는 삭제하지 않는다. TRUNCATE TABLE table_name;

SQL CREATE TABLE Statement The SQL CREATE TABLE Statement 데이터베이스에 새 테이블 생성하기 CREATE TABLE table_name ( column1 datatype, column2 datatype, column3 datatype, ... ); SQL CREATE TABLE Example CREATE TABLE Persons ( PersonID int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255) ); Create Table Using Another Table 동일한 열 정의를 가져오는 테이블 CREATE TABLE new_table_name AS..

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..