SQL Server

SQL server-for-beginner

스키마란?

-명세서 개념
-DB를 어떻게 구성할지
-일종의 설계도
https://www.youtube.com/watch?v=RcxXlBKBKmQ

MS-SQL	HOW-TO-USE
GO	쿼리를 끝맺을 때
USE [master]	master 테이블로 이동
CREATE DATABASE [table] ON PRIMARY CREATE DATABASE [table] : 테이블 생성 ON PRIMARY : PRIMARY 그룹에 저장	https://docs.microsoft.com/ko-kr/sql/relational-databases/databases/create-a-database?view=sql-server-2017 http://www.sqler.com/index.php?mid=bSQLQA&page=7&document_srl=502186 https://mozi.tistory.com/293
ALTER DATABASE [table] SET (ex)ALTER DATABASE [table] SET COMPATIBILITY_LEVEL = 100 (ex)ALTER DATABASE [table] SET ANSI_NULLS OFF	데이터베이스 옵션 설정 (MSSQL)https://docs.microsoft.com/ko-kr/sql/t-sql/statements/alter-database-transact-sql-set-options?view=sql-server-2017 (ORACLE)http://www.gurubee.net/lecture/1086
https://docs.microsoft.com/ko-kr/sql/t-sql/statements/alter-database-transact-sql-compatibility-level?view=sql-server-2017 SET COMPATIBILITY_LEVEL : 호환성 수준 https://docs.microsoft.com/ko-kr/sql/t-sql/statements/set-ansi-null-dflt-on-transact-sql?view=sql-server-2017 SET ANSI_NULL_DEFAULT : 기본 null허용 여부보다 우선 적용 https://ellieya.tistory.com/54 SET ANSI_NULLS : null, 0 반환 관련 http://time2relax.net/wp/?p=372 SET ANSI_PADDING : 공백 https://m.blog.naver.com/PostView.nhn?blogId=b1ackjean&logNo=220329283248&proxyReferer=&proxyReferer=https%3A%2F%2Fwww.google.com%2F SET ANSI_WARNINGS http://www.taeyo.net/Forum/Content.aspx?SEQ=1334&TBL=KNOWHOW SET ARITHABORT https://vstarmanv.tistory.com/175 SET AUTO_CLOSE </tr>
sp_fulltext_database	이전 버전과 호환 유지 https://docs.microsoft.com/ko-kr/sql/relational-databases/system-stored-procedures/sp-fulltext-database-transact-sql?view=sql-server-2017
FULLTEXTSERVICEPROPERT	전체 텍스트 엔진의 속성과 관련된 정보를 반환 https://docs.microsoft.com/ko-kr/sql/t-sql/functions/fulltextserviceproperty-transact-sql?view=sql-server-2017
CREATE USER [user_name] FOR LOGIN [user_name] WITH DEFAULT_SCHEMA=[dbo]	현재 데이터베이스에 사용자를 추가 https://docs.microsoft.com/ko-kr/sql/t-sql/statements/create-user-transact-sql?view=sql-server-2017
CREATE TABLE [dbo].[table_name]( .... )ON [PRIMARY]	테이블 생성
sp_addextendedproperty : 확장속성 추가 sp_updateextendedproperty : 확장속성 수정 sp_dropextendedproperty : 확장속성 삭제	https://m.blog.naver.com/PostView.nhn?blogId=islove8587&logNo=220611473304&proxyReferer=https%3A%2F%2Fwww.google.com%2F
	</table>