본문 바로가기
  • Seizure But Okay Developer
BackEnd/SQL 관련자료

MSSQL 관련 정보

by Sky_Developer 2024. 1. 15.

MSSQL 데이터 수정시 날짜 자동업데이트

https://stackoverflow.com/questions/21493178/need-a-datetime-column-in-sql-server-that-automatically-updates-when-the-record

 

MSSQL DB 생성 방법

https://server-talk.tistory.com/248

 

Oracle To MSSQL Migration DataType Convert Tip

https://docs.oracle.com/cd/E10405_01/appdev.120/e10379/ss_oracle_compared.htm

 

세로 출력을 가로 출력으로 바꾸기

https://goldswan.tistory.com/9#google_vignette

 

쿼리를 월별로 집계하는 방법

https://stackoverflow.com/questions/8345282/how-to-group-by-month-using-sql-server

 

댓글