|
|
- 구입목록에 있는 프로그램들 전부 설치 및 업데이트
- Microsoft Remote Desktop
- Microsoft OneNote
- OneDrive
- Notability
- CheetSheet
- GoodNote 5
- VsCode
- Valentina Studio
- Friendly Streaming Browser
- Facebook Messenger
- Skype
- Amphetamine
- SnailGit
- SnailSVN
- HazeOver
- Slack
- deepClock
- 한컴오피스 한글 2014 VP 뷰어
- 무비스트
- 카카오톡
- 네이트온
- Band
- Telegram
- isHUD
- MachineProfile
- Blackmagic Disk Speed Test
- 각 홈페이지 가서 설치해야 하는 프로그램
- Command Line tools
- Brew Install
- composer
- git
- go
- htop
- midnight-commander
- neovim
- nmap
- node
- php-code-sniffer
- php-cd-fixer
- python3
- sdl2
- subversion
- tmux
- zsh
- zsh-completions
- tickeys
- casks font-hack-nerd-font
- casks iterms
- casks meld
- 쓰고 싶은 프로그램
|
|
SELECT db_name(st.dbid) DBName , object_schema_name(objectid, st.dbid) SchemaName , object_name(objectid, st.dbid) SPName , qs.total_elapsed_time , creation_time , last_execution_time , text FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_sql_text(qs.plan_handle)st JOIN sys.dm_exec_cached_plans cp ON qs.plan_handle = cp.plan_handle |
|
|
select year as '년', month as '월', count(*) as count from ( select YEAR(us.fd_dtcreate) as 'year', MONTH(us.fd_dtcreate) as 'month' from tb_ykfile as us where us.fd_dtCreate > '2020-08-01' and us.fd_dtCreate <= '2022-01-01' ) tb group by year, month order by year, month ; |
|
|
SELECT CONVERT(varCHAR(10),Dateadd(d, a.number,'2020-08-01 00:00:00'),120) AS dt ,Isnull(b.count, 0) AS count FROM master..spt_values a LEFT JOIN ( SELECT count(*) AS count, CONVERT(CHAR(10), b1.fd_dtcreate,120) AS fd_dtcreate FROM tb_ykfile b1 WITH(nolock) GROUP BY CONVERT(CHAR(10), b1.fd_dtcreate, 120) ) b ON CONVERT(CHAR(10), Dateadd(d, a.number,'2020-08-01 00:00:00'), 120) = b.fd_dtcreate WHERE TYPE = 'P' AND CONVERT(CHAR(10), DATEADD(D, NUMBER, '2020-08-01'), 120) <= '2022-01-01' order by dt ; |
|
링크
|
