Take any MS SQL Server table or view, export the data as a JSON file

Author: Ahliana Byrd, 20151201 Purpose: To take any table or view, export the data as a JSON file

EXAMPLE: EXEC SQLTableOrViewToJSON 'MyTable', 'C:\WhereIStowMyJSON'

WARNING: This code will enable xp_cmdshell WARNING: This code will create 2 tables and leave them so they can be checked later, easier for debugging WARNING: This code will create a saved stored procedure, SQLTableOrViewToJSON

This creates a string to declare variables, declare a cursor, walk the cursor, and output the resulting strings to a table The string is then executed, so that the entire procedure is essentially done in a virtual memory space The string that will be executed is printed in the Messages window, so if something doesn't seem to be working, you can scroll down, grab the generated script, and paste it into a new window so you can debug it

Metadata code by: marc_s on StackOverflow, http://stackoverflow.com/questions/2418527/sql-server-query-to-get-the-list-of-columns-in-a-table-along-with-data-types-no