메모장입니다.

UPDATE TableA (또는 Alias이름)
SET foo = B.bar
FROM TableA A
    INNER JOIN TableB B ON A.col1 = B.colx
WHERE ...

DELETE TableA (또는 Alias이름)
FROM TableA A
    INNER JOIN TableB B ON A.ID=B.ID
WHERE ....

SELECT DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0);

$('#id').click(function() {
    $(this).select()
}).blur(function() {
    if(window.getSelection) {
        var sel = window.getSelection();
        if(sel.collapse)
            sel.collapse($(this)[0], 0); //firefox의 경우 removeAllRanges는 동작안되는 경우가 있음
        else
            sel.removeAllRanges();
    } else if(document.selection) {
        document.selection.empty();
    }
});

history.pushState(null, null, location.href);
window.onpopstate = function(event) {
    history.go(1);
};