JSON Serialization and Deserialization

Found a good articale on JSON Serialization and Deserialization: http://www.codeproject.com/Articles/272335/JSON-Serialization-and-Deserialization-in-ASP-NET I used this article to create a class that serializes DataSet, DataTable and DataRow objects: I just changed one aspect of the codeproject article, I used the regular expression "\\/Date\((-?\d+)\)\\/" instead of  “\\/Date\((\d+)\+\d+\)\\/”. The regular expression “\\/Date\((-?\d+)\)\\/” takes into account …

How to insert the result of a stored procedure in a table variable

Found the solution at: http://stackoverflow.com/questions/653714/how-to-select-into-temp-table-from-stored-procedure The following T-SQL code executes the system stored procedure sp_helpfile and stores the result in the table variable @temp.   declare @temp table (     name varchar(255),     field varchar(255),     filename varchar(255),     filegroup varchar(255),     size varchar(255),     maxsize varchar(255),     growth varchar(255), …