Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE+DATABASE+TestDB%3B%0AGO%0AUSE+TestDB%3B%0ACREATE+TABLE+test+%28%0Aid+int+IDENTITY%2C%0Apdate+datetime%29%3B%0AINSERT+test%0AVALUES%28%271-Feb-2018%27%29%2C%28%271-Mar-2018%27%29%2C%28NULL%29%3B%0A%09%0ASELECT+%2A+FROM+test%0A%09%0ASELECT+%2A+FROM%0A++++%28%0A++++++++SELECT%0A++++++++++++id%2C%0A++++++++++++IIF%28pdate+IS+NULL%2C+%27%27%2C+FORMAT%28pdate%2C+%27yyyy-MM-dd%27%29%29+pdate2%0A++++++++FROM+test%0A++++%29+a%0AWHERE+pdate2+%3D+%27%27%0A%09%0ASELECT+%2A+FROM%0A++++%28%0A++++++++SELECT%0A++++++++++++id%2C%0A++++++++++++IIF%28pdate+IS+NULL%2C+%27%27%2C+FORMAT%28pdate%2C+%27yyyy-MM-dd%27%29%29+pdate2%0A++++++++FROM+test%0A++++%29+a%0AWHERE+pdate2+%3D+%27++++%27%0A%09%0ASELECT+%2A+FROM%0A++++%28%0A++++++++SELECT%0A++++++++++++id%2C%0A++++++++++++IIF%28pdate+IS+NULL%2C+%27%27%2C+FORMAT%28pdate%2C+%27yyyy-MM-dd%27%29%29+pdate2%0A++++++++FROM+test%0A++++%29+a%0AWHERE+pdate2+LIKE+%27++++%27
Add Comment
Please, Sign In to add comment