Sahachai Y. daddybannk

## settings.json
{
    "[json]": {
        "editor.defaultFormatter": "vscode.json-language-features",
        "editor.tabSize": 4,
        "editor.formatOnSave": true,
        "editor.insertSpaces": true,
        "editor.detectIndentation": false,
    },
}

## gist:e64dfefcf25f79590223ecacda614009
flutter pub cache clean

## index.html
<a href="javascript:void(0)" onClick="myFunction">Click Me!</a>

## ubuntu_install_new_node_version.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                daddybannk
                / ubuntu_install_new_node_version.md
            
            
              Created
              September 27, 2023 08:53
            
          
    apt purge nodejs
apt autoremove
apt install nodejs


## git_resolve_folder_rename
git rm -r --cached .
git add --all .

## config
Host daddybannk
    HostName ssh.github.com
    IdentityFile ~/.ssh/id_rsa
    User git

Host {name_other}
    HostName ssh.github.com
    IdentityFile ~/.ssh/{id_rsa_other}
    User git

## fifteen_minute_round_time.sql
SELECT CONVERT(DATETIME, DATEADD(SECOND, ROUND(DATEDIFF(s, '1970-01-01', GETDATE()) / 900.0,0) * 900.0, '1970-01-01')) FIFTEEN_MINUTE_ROUND_TIME

## sql_resolve_conflict_datatype.sql
SELECT *
FROM TABLE_A
LEFT OUTER JOIN TABLE_B ON TABLE_A.COL1 COLLATE Thai_CI_AI_KS = TABLE_B.COL1 COLLATE Thai_CI_AI_KS

## example_max_score_each_day.sql
SELECT INSERT_DATE, INSERT_TIME, PLAYER_NUM, PLAYER_SCORE
FROM (
	SELECT ROW_NUMBER() OVER (
	PARTITION BY CONVERT(DATE, INSERT_TIME)
	ORDER BY PLAYER_SCORE DESC, INSERT_TIME DESC
	) ROW_NUM, CONVERT(DATE, INSERT_TIME) INSERT_DATE, INSERT_TIME, PLAYER_NUM, PLAYER_SCORE
	FROM TABLE_SCORE
) A1 WHERE ROW_NUM = 1

## sql_auto_increment.sql
SELECT COALESCE(MAX(YOUR_INT_ID), 0) + 1
	{
	"[json]": {
	"editor.defaultFormatter": "vscode.json-language-features",
	"editor.tabSize": 4,
	"editor.formatOnSave": true,
	"editor.insertSpaces": true,
	"editor.detectIndentation": false,
	},
	}
	Host daddybannk
	HostName ssh.github.com
	IdentityFile ~/.ssh/id_rsa
	User git

	Host {name_other}
	HostName ssh.github.com
	IdentityFile ~/.ssh/{id_rsa_other}
	User git
	SELECT *
	FROM TABLE_A
	LEFT OUTER JOIN TABLE_B ON TABLE_A.COL1 COLLATE Thai_CI_AI_KS = TABLE_B.COL1 COLLATE Thai_CI_AI_KS
	SELECT INSERT_DATE, INSERT_TIME, PLAYER_NUM, PLAYER_SCORE
	FROM (
	SELECT ROW_NUMBER() OVER (
	PARTITION BY CONVERT(DATE, INSERT_TIME)
	ORDER BY PLAYER_SCORE DESC, INSERT_TIME DESC
	) ROW_NUM, CONVERT(DATE, INSERT_TIME) INSERT_DATE, INSERT_TIME, PLAYER_NUM, PLAYER_SCORE
	FROM TABLE_SCORE
	) A1 WHERE ROW_NUM = 1