October, 2002
On Target with ADO.NET
Trying 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.
SQL Server Magazine
|
December, 2001
Turning Strings into Tables
A reader shares a tip for using fn_Split() to create a table-valued function that transforms row- and column-delimited strings into tables.
SQL Server Magazine
|
June, 2001
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
SQL Server Magazine
|