어느용

MSSQL Paging

          SELECT row_number() OVER(ORDER BY fd_nIdService DESC) AS PagedNumber, *
          FROM [tb_Service] AS [t]
          WHERE 1=1
          ORDER BY [fd_nIdService] DESC
          OFFSET ((2 - 1) * 10) ROWS FETCH NEXT 10 ROWS ONLY

SELECT row_number() OVER(ORDER BY fd_nIdService DESC) AS PagedNumber, *

FROM [tb_Service] AS [t]

WHERE 1=1

ORDER BY [fd_nIdService] DESC

OFFSET ((2 - 1) * 10) ROWS FETCH NEXT 10 ROWS ONLY

VIM Encoding

encoding, fileencoding, fileencodings 옵션 차이

encoding 은 화면에 보이는 것, 시스템이나 터미널에 관련되어 있지 파일 자체에는 관계 없다
fileencoding 은 파일에 저장되는 코드, encoding 과 fileencoding 이 같으면 (보통 euc-kr 이나 cp949?) 상관없고 이 둘이 다르면 파일을 읽거나 쓸 때 변환이 된다.
fileencodings 에는 여러 인코딩 룰을 적어주면 파일을 읽을 때 하나씩 검사해서 맞는 인코딩을 찾아내어 자동으로 fileencoding 을 세팅해준다.
새파일이면 터미널의 인코딩대로 저장되고 있던파일이면 원래 파일 인코딩대로 저장됩니다.

Sort Time

Algorithm	Average Time	Worst Time	Space
Bubble sort	n^2	n^2	1
Selection sort	n^2	n^2	1
Counting Sort	n+k	n+k	n+k
Insertion sort	n^2	n^2
Quick sort	n log(n)	n^2
Merge sort	n log(n)	n log(n)	depends

CSharp Library

Sharpzip – 압축 관리
FluentEmail – Email 관리
MailKit – Email 관리
Papercut-SMTP – Email 관리
EPPlus – 엑셀 관리
Hangfire – Service가 아니지만 백그라운드로 도는 프로그램을 만들때 사용
MassTransit – RabbitMQ등
Polly – 오류 처리
Seq – 중앙 집중식 로그

Web에서 Proxy를 쓰는 사용자 Real IP 구하기

<?php 
 function getRealIpAddr(){ 
    if(!empty($_SERVER['HTTP_CLIENT_IP']) && getenv('HTTP_CLIENT_IP')){ 
        return $_SERVER['HTTP_CLIENT_IP']; 
    }
    elseif(!empty($_SERVER['HTTP_X_FORWARDED_FOR']) && getenv('HTTP_X_FORWARDED_FOR')){ 
        return $_SERVER['HTTP_X_FORWARDED_FOR']; 
    }
    elseif(!empty($_SERVER['REMOTE_HOST']) && getenv('REMOTE_HOST')){ 
        return $_SERVER['REMOTE_HOST']; 
    }
    elseif(!empty($_SERVER['REMOTE_ADDR']) && getenv('REMOTE_ADDR')){ 
        return $_SERVER['REMOTE_ADDR']; 
    } 
    return false; 
 }


 if($ip = getRealIpAddr()){
     echo $ip;
 }
 ?>

<?php

function getRealIpAddr(){

if(!empty($_SERVER['HTTP_CLIENT_IP']) && getenv('HTTP_CLIENT_IP')){

return $_SERVER['HTTP_CLIENT_IP'];

}

elseif(!empty($_SERVER['HTTP_X_FORWARDED_FOR']) && getenv('HTTP_X_FORWARDED_FOR')){

return $_SERVER['HTTP_X_FORWARDED_FOR'];

}

elseif(!empty($_SERVER['REMOTE_HOST']) && getenv('REMOTE_HOST')){

return $_SERVER['REMOTE_HOST'];

}

elseif(!empty($_SERVER['REMOTE_ADDR']) && getenv('REMOTE_ADDR')){

return $_SERVER['REMOTE_ADDR'];

}

return false;

}

if($ip = getRealIpAddr()){

echo $ip;

}

VSCODE 단축키

// Write on multiple lines
Shift + Option + Command + Up Down Arrow keys
Shift + Option + Mouse Click

// Place cursor at multiple locations
Option + Mouse Click

// Select multiple similar words with cursor at multiple locations
Command + D

// Opening the same file in a new Tab
Command + \

// Hideing the left Sidebar
Command + B

// Goto Function 
Command + Option + Click

// Open Terminal
Command + J

// Write on multiple lines

Shift + Option + Command + Up Down Arrow keys

Shift + Option + Mouse Click

// Place cursor at multiple locations

Option + Mouse Click

// Select multiple similar words with cursor at multiple locations

Command + D

// Opening the same file in a new Tab

Command + \

// Hideing the left Sidebar

Command + B

// Goto Function

Command + Option + Click

// Open Terminal

Command + J

media query Size

부트스트랩의 그리드 class
 .col-xl- (초대형 장치)
 .col-lg- (대형 장치 - 화면 너비가 1200 px 미만)
 .col-md- (중간 크기 장치 - 화면 너비가 992px 미만)
 .col-sm- (소형 장치 - 화면 너비가 768px 미만)
 .col- (소형 장치 - 화면 너비가 576px 미만)
 .col (기본값 - 자동으로 반응)

부트스트랩의 그리드 class

.col-xl- (초대형 장치)

.col-lg- (대형 장치 - 화면 너비가 1200 px 미만)

.col-md- (중간 크기 장치 - 화면 너비가 992px 미만)

.col-sm- (소형 장치 - 화면 너비가 768px 미만)

.col- (소형 장치 - 화면 너비가 576px 미만)

.col (기본값 - 자동으로 반응)

기본 - 데스크탑

@media (min-width: 1281px)
- 랩탑, 데스크탑

@media (min-width: 1025px)
- 태블릿, 아이패드 (세로)

@media (min-width: 768px)
- 태블릿, 아이패드 (가로)

@media (min-width: 481px)
- 저해상도 태블릿, 모바일 (가로)

@media (min-width: 320px) 
- 대부분의 스마트폰 모바일 기기 (세로)

기본 - 데스크탑

@media (min-width: 1281px)

- 랩탑, 데스크탑

@media (min-width: 1025px)

- 태블릿, 아이패드 (세로)

@media (min-width: 768px)

- 태블릿, 아이패드 (가로)

@media (min-width: 481px)

- 저해상도 태블릿, 모바일 (가로)

@media (min-width: 320px)

- 대부분의 스마트폰 모바일 기기 (세로)

/* Smartphones (portrait and landscape) ----------- */
@media only screen and (min-device-width : 320px) and (max-device-width : 480px) {
/* Styles */
}

/* Smartphones (landscape) ----------- */
@media only screen and (min-width : 321px) {
/* Styles */
}

/* Smartphones (portrait) ----------- */
@media only screen and (max-width : 320px) {
/* Styles */
}

/* iPads (portrait and landscape) ----------- */
@media only screen and (min-device-width : 768px) and (max-device-width : 1024px) {
/* Styles */
}

/* iPads (landscape) ----------- */
@media only screen and (min-device-width : 768px) and (max-device-width : 1024px) and (orientation : landscape) {
/* Styles */
}

/* iPads (portrait) ----------- */
@media only screen and (min-device-width : 768px) and (max-device-width : 1024px) and (orientation : portrait) {
/* Styles */
}
/**********
iPad 3
**********/
@media only screen and (min-device-width : 768px) and (max-device-width : 1024px) and (orientation : landscape) and (-webkit-min-device-pixel-ratio : 2) {
/* Styles */
}

@media only screen and (min-device-width : 768px) and (max-device-width : 1024px) and (orientation : portrait) and (-webkit-min-device-pixel-ratio : 2) {
/* Styles */
}
/* Desktops and laptops ----------- */
@media only screen  and (min-width : 1224px) {
/* Styles */
}

/* Large screens ----------- */
@media only screen  and (min-width : 1824px) {
/* Styles */
}

/* iPhone 4 ----------- */
@media only screen and (min-device-width : 320px) and (max-device-width : 480px) and (orientation : landscape) and (-webkit-min-device-pixel-ratio : 2) {
/* Styles */
}

@media only screen and (min-device-width : 320px) and (max-device-width : 480px) and (orientation : portrait) and (-webkit-min-device-pixel-ratio : 2) {
/* Styles */
}

/* iPhone 5 ----------- */
@media only screen and (min-device-width: 320px) and (max-device-height: 568px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 2){
/* Styles */
}

@media only screen and (min-device-width: 320px) and (max-device-height: 568px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 2){
/* Styles */
}

/* iPhone 6, 7, 8 ----------- */
@media only screen and (min-device-width: 375px) and (max-device-height: 667px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 2){
/* Styles */
}

@media only screen and (min-device-width: 375px) and (max-device-height: 667px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 2){
/* Styles */
}

/* iPhone 6+, 7+, 8+ ----------- */
@media only screen and (min-device-width: 414px) and (max-device-height: 736px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 2){
/* Styles */
}

@media only screen and (min-device-width: 414px) and (max-device-height: 736px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 2){
/* Styles */
}

/* iPhone X ----------- */
@media only screen and (min-device-width: 375px) and (max-device-height: 812px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 3){
/* Styles */
}

@media only screen and (min-device-width: 375px) and (max-device-height: 812px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 3){
/* Styles */
}

/* iPhone XS Max, XR ----------- */
@media only screen and (min-device-width: 414px) and (max-device-height: 896px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 3){
/* Styles */
}

@media only screen and (min-device-width: 414px) and (max-device-height: 896px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 3){
/* Styles */
}

/* Samsung Galaxy S3 ----------- */
@media only screen and (min-device-width: 320px) and (max-device-height: 640px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 2){
/* Styles */
}

@media only screen and (min-device-width: 320px) and (max-device-height: 640px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 2){
/* Styles */
}

/* Samsung Galaxy S4 ----------- */
@media only screen and (min-device-width: 320px) and (max-device-height: 640px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 3){
/* Styles */
}

@media only screen and (min-device-width: 320px) and (max-device-height: 640px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 3){
/* Styles */
}

/* Samsung Galaxy S5 ----------- */
@media only screen and (min-device-width: 360px) and (max-device-height: 640px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 3){
/* Styles */
}

@media only screen and (min-device-width: 360px) and (max-device-height: 640px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 3){
/* Styles */
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

/* Smartphones (portrait and landscape) ----------- */

@media only screen and (min-device-width : 320px) and (max-device-width : 480px) {

/* Styles */

}

/* Smartphones (landscape) ----------- */

@media only screen and (min-width : 321px) {

/* Styles */

}

/* Smartphones (portrait) ----------- */

@media only screen and (max-width : 320px) {

/* Styles */

}

/* iPads (portrait and landscape) ----------- */

@media only screen and (min-device-width : 768px) and (max-device-width : 1024px) {

/* Styles */

}

/* iPads (landscape) ----------- */

@media only screen and (min-device-width : 768px) and (max-device-width : 1024px) and (orientation : landscape) {

/* Styles */

}

/* iPads (portrait) ----------- */

@media only screen and (min-device-width : 768px) and (max-device-width : 1024px) and (orientation : portrait) {

/* Styles */

}

/**********

iPad 3

**********/

@media only screen and (min-device-width : 768px) and (max-device-width : 1024px) and (orientation : landscape) and (-webkit-min-device-pixel-ratio : 2) {

/* Styles */

}

@media only screen and (min-device-width : 768px) and (max-device-width : 1024px) and (orientation : portrait) and (-webkit-min-device-pixel-ratio : 2) {

/* Styles */

}

/* Desktops and laptops ----------- */

@media only screen and (min-width : 1224px) {

/* Styles */

}

/* Large screens ----------- */

@media only screen and (min-width : 1824px) {

/* Styles */

}

/* iPhone 4 ----------- */

@media only screen and (min-device-width : 320px) and (max-device-width : 480px) and (orientation : landscape) and (-webkit-min-device-pixel-ratio : 2) {

/* Styles */

}

@media only screen and (min-device-width : 320px) and (max-device-width : 480px) and (orientation : portrait) and (-webkit-min-device-pixel-ratio : 2) {

/* Styles */

}

/* iPhone 5 ----------- */

@media only screen and (min-device-width: 320px) and (max-device-height: 568px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 2){

/* Styles */

}

@media only screen and (min-device-width: 320px) and (max-device-height: 568px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 2){

/* Styles */

}

/* iPhone 6, 7, 8 ----------- */

@media only screen and (min-device-width: 375px) and (max-device-height: 667px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 2){

/* Styles */

}

@media only screen and (min-device-width: 375px) and (max-device-height: 667px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 2){

/* Styles */

}

/* iPhone 6+, 7+, 8+ ----------- */

@media only screen and (min-device-width: 414px) and (max-device-height: 736px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 2){

/* Styles */

}

@media only screen and (min-device-width: 414px) and (max-device-height: 736px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 2){

/* Styles */

}

/* iPhone X ----------- */

@media only screen and (min-device-width: 375px) and (max-device-height: 812px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 3){

/* Styles */

}

@media only screen and (min-device-width: 375px) and (max-device-height: 812px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 3){

/* Styles */

}

/* iPhone XS Max, XR ----------- */

@media only screen and (min-device-width: 414px) and (max-device-height: 896px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 3){

/* Styles */

}

@media only screen and (min-device-width: 414px) and (max-device-height: 896px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 3){

/* Styles */

}

/* Samsung Galaxy S3 ----------- */

@media only screen and (min-device-width: 320px) and (max-device-height: 640px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 2){

/* Styles */

}

@media only screen and (min-device-width: 320px) and (max-device-height: 640px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 2){

/* Styles */

}

/* Samsung Galaxy S4 ----------- */

@media only screen and (min-device-width: 320px) and (max-device-height: 640px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 3){

/* Styles */

}

@media only screen and (min-device-width: 320px) and (max-device-height: 640px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 3){

/* Styles */

}

/* Samsung Galaxy S5 ----------- */

@media only screen and (min-device-width: 360px) and (max-device-height: 640px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 3){

/* Styles */

}

@media only screen and (min-device-width: 360px) and (max-device-height: 640px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 3){

/* Styles */

}

MSSQL Table List Query

(10%) select name from sysobjects where type='U'
(13%) select * from information_schema.tables
(76%) select * from sys.tables

(10%) select name from sysobjects where type='U'

(13%) select * from information_schema.tables

(76%) select * from sys.tables

Load Avg

다른건 그냥 웹에서 찾아보고
CPU Core 갯수를 가져오면

sysctl hw.ncpu | awk '{print $2}'

1	sysctl hw.ncpu \| awk '{print $2}'

load Avg가 저 수치가 되면 모든 cpu의 core를 100% 사용하고 있다는 거…

cmd 대신 사용하는 powershell 의 prompt에서 git branch확인

[bash] Install-Module posh-git -Scope CurrentUser Install-Module oh-my-posh -Scope CurrentUser [/bash] [bash] if (!(Test-Path -Path $PROFILE )) { New-Item -Type File -Path $PROFILE -Force } notepad.exe $PROFILE [/bash] admin 권한으로 [bash]Set-ExecutionPolicy -Scope LocalMachine -ExecutionPolicy RemoteSigned -Force[/bash] notepad에서 [bash]import-module posh-git import-module oh-my-posh set-theme agnoster [/bash] 그리고 폰트를 D2Coding으로 변경 기왕이면 바탕 화면 색도 검정색으로 변경

어느용

날자별

참고자료

보관함

MSSQL Paging

VIM Encoding

Sort Time

CSharp Library

Web에서 Proxy를 쓰는 사용자 Real IP 구하기

VSCODE 단축키

media query Size

MSSQL Table List Query

Load Avg

cmd 대신 사용하는 powershell 의 prompt에서 git branch확인

AD

최신 글

메타

날자별

참고자료

보관함

태그

이 글 공유하기:

이 글 공유하기:

이 글 공유하기:

이 글 공유하기:

이 글 공유하기:

이 글 공유하기:

이 글 공유하기:

이 글 공유하기:

이 글 공유하기:

이 글 공유하기:

AD

최신 글

메타