Month: April 2012

JSON Serialization and Deserialization

13 April, 2012 Roel van Lisdonk 0 Comments 1 category

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

Read More

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

2 April, 2012 Roel van Lisdonk 0 Comments 1 category

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),

Read More