Chapter 8. Inserting Data and Transactions
We have now built our tables, set up the relationships, and backed up our solution, so we are ready to start inserting data. The many tables within the database cover a number of different types of data that can be stored, ranging from characters and numbers to XML. This chapter will show you how to insert data into columns defined with all these data types.
Not all the tables will be populated with data at this point. We will insert data in other tables later in the book when different functionality of SSE is being demonstrated. Although data is being inserted, the database is still at the stage of being set up, because we are inserting static information at this point in the examples we are building ...
Get Beginning SQL Server 2008 Express for Developers: From Novice to Professional now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
