The PS4 can upload screenshots from both within and outside of games. To capture and upload a screenshot, press the Share button on the DualShock 4. This takes a snapshot and opens a menu.
DROP TABLE goes further than a TRUNCATE in that it actually removes the table from the database completely. This includes removing all associated objects, such as indexes and constraints. If you dropped a table, not only would you remove all the data, but the structure as well.
COALESCE is based on the ANSI SQL standard whereas ISNULL is a proprietary TSQL function. 6. You could get different plans for queries using ISNULL & COALESCE if the expressions involve scalar sub-queries. This will make a performance difference and queries with COALESCE often fare worse here.