Passing a Set of Data to Microsoft SQL Server 2008: How, What, and Why

  • Date: June 10, 2010 from 2:15PM to 3:30PM
  • Day 4
  • DAT404
  • Speakers: Tobias Ternstrom

  • Avg Rating: 0

  • 73 Views

Embed code for this video

Copy the code above to embed our video on your website/blog.

Close

Video format

Note: These selections will fall back to the next best format depending upon browser capability.

Close

Download

How do I download the videos?

  • To download, right click the file type you would like and pick “Save target as…” or “Save link as…”

Why should I download videos from Channel9?

  • It's an easy way to save the videos you like locally.
  • You can save the videos in order to watch them offline.
  • If all you want is to hear the audio, you can download the MP3!

Which version should I choose?

  • If you want to view the video on your PC, Xbox or Media Center, download the High Quality WMV file (this is the highest quality version we have available).
  • If you'd like a lower bitrate version, to reduce the download time or cost, then choose the Medium Quality WMV file.
  • If you have a Zune, WP7, iPhone, iPad, or iPod device, choose the low or medium MP4 file.
  • If you just want to hear the audio of the video, choose the MP3 file.

Right click “Save as…”

Slides (view online)
This session covers the obscure territory of passing sets of data from a client application to SQL Server. There are (almost) countless solutions to this task; use of the SQL Server 2008 feature Table Valued Parameters (TVPs), XML, strings, Bulk Copy, etc. In this session we describe as well as compare many of these approaches. We also look into what stored procedures brings to the table as well as using the new MERGE statement. A discussion on pros and cons and performance aspects of each approach, as well as a look at end-to-end demos is a promise!

Comments Closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.

Event Homepage

Tech·Ed North America 2010

More sessions in this event

See More

Related sessions

Creative Commons License

© 2012 Microsoft. Except where designated as licensed by
Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 License,
Microsoft reserves all rights associated with the materials on this site.