Revolutionize Your Data Programming with Microsoft SQL Server Table Value Parameters
Play Revolutionize Your Data Programming with Microsoft SQL Server Table Value Parameters
Such an innocuous name - "table-valued parameters" - for a radical new feature in SQL Server 2008! It sounds like the sort of thing that only a geek could love: pass a table to a procedure and/or get a table back. But it will forever change the way you think about programming SQL Server! 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. Explore this new feature, 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!