SQL Server Heroes


Click to preview our action-packed agenda

PASS Community Summit 2008: Spotlight Session (Application Development)

Table Value Parameters Revolutionize Data Programming!

Don Kiely

Session Details


Such an innocuous name—table value parameters—for a radical new feature in SQL Server 2008! It’s the sort of thing that sounds like only a geek could love: pass a table to a procedure and/or get a table back. But it will change the way you think about programming SQL Server forever! If you’ve ever passed a comma or other delimited list of data values to a stored procedure, then split them up and processed them, or bumped up against the parameter limits, you know the pain that is now forever gone. In this session we’ll explore this new features, including the syntax and how to make use of it, both in SQL Server code as well as client code. You’ll leave the session wondering how you ever programmed without them!

Register Now for PASS Community Summit 2008!