Tracy’s Blog

Take your work seriously…but never yourself.

More Fun with XML (and SQL Server 2005)

Standing on SHoulder There is simply nothing more fulfilling and gratifying in the world of software development than solving a tough problem with an elegant, robust and scaleable solution.

Welllll…exxxxcept for googling your problem, standing on the shoulders of other programming geniuses, and using their elegant, robust, and scaleable solutions to solve your own tough problem. Programmers are inherently lazy and I’m no exception. So when I stumbled onto this little URL gem describing an elegant, scaleable, robust and plug-n-play-like method to providing a dynamic and variable number of parameters to a SQL stored procedure; I thought I’d share it with my fellow engineers.

Passing Lists to SQL Server 2005 with XML parameters.

[FYI; you must have Sql Server 2005 or greater].

Advertisements

December 12, 2007 - Posted by | Tech

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: