http://www.sqlmag.com/authors/author/author/5777648/rss/5777648en-USFri, 25 May 2012 08:56:45 GMTFri, 25 May 2012 08:56:45 GMThttp://www.sqlmag.com/article/tsql3/on-target-with-ado-netTrying to keep up with changing data in your reports? You can provide variable-width crosstab reports by using dynamic SQL. But ADO.NET’s relational features provide a more flexible, efficient, and secure solution.]]>Burton RobertsWed, 23 Oct 2002 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/on-target-with-ado-nethttp://www.sqlmag.com/article/tsql3/turning-strings-into-tablesA reader shares a tip for using fn_Split() to create a table-valued function that transforms row- and column-delimited strings into tables.]]>Burton RobertsSat, 01 Dec 2001 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/turning-strings-into-tableshttp://www.sqlmag.com/article/stored-procedures/treat-yourself-to-fn_split-This copycat UDF, created in the image of VB’s Split() function, helped the author parse thousands of query lines and emulate variable-length parameter arrays]]>Burton RobertsWed, 20 Jun 2001 00:00:00 GMThttp://www.sqlmag.com/article/stored-procedures/treat-yourself-to-fn_split-