| 8. Database (MSSQL) | 0) 왜 DB를 사용하는가? 1) Table Design. ERD 2) Query (Group, Having) 2-1) Query (Join) 3) 관리(MDF, LDF, ndf, Services), Backup, Restore. 3-1) Detach, Attach vs backup, restore 4) SP, function 5) Trigger 6) Linked Server(Good,Bad and OPENQUERY) 7) View 8) Jobs 9) DB --> Email(Alarm or Warning) 10) MSSQL 성능향상. 11) Delete vs Truncate vs Drop 99) where 1=1은 어디에 사용되나? |
MSSQL
2021. 5. 20. 12:39