Skip to content

Instantly share code, notes, and snippets.

@10nin

10nin/hear_document.js

Created September 10, 2018 14:12
Show Gist options
  • Save 10nin/52d1aec0a986196188521adac1b02b53 to your computer and use it in GitHub Desktop.
Save 10nin/52d1aec0a986196188521adac1b02b53 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
hear_document.js
var q = function(){/*
SELECT '"' + FB.hogehoge + '","' + FB.fugafuga + '","' + IsNull(ABCD.piyopiyo, ' ') + '"' AS Line
FROM FooBar AS FB
INNER JOIN ABCDE
ON FB.Id = ABCD.foobarId
AND ABCD.Name = '$1'
AND FB.Active = $2
*/}.toString().split("\n").slice(1,-1).join("\n");
strSQL = q.replace('$1', parameter1)
.replace('$2', parameter2)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment