Hi all,
1) I tried to learn the stuffs of Try It Out on Pages 32-33 (Using SELECT, WHERE, INSERT, DELETE and UPDATE) and Pages 34-35 (Creating and Using Stored Procedures) after I created the database "testDb".
When I created these 2 sets of Try It Out code statements for the first time, I got the output nicely as shown Figure 2-6 in the Book.
But after few days, I re-executed these 2 sets of the code statement and I got some weird Build errors that I do not have any ideas what they means. Did any one have the same thing happened to you? Can you tell me whether these 2 sets of code statements can be used for the one-time only or what!!??
2) I read "SQL Server Express Samples Overview (from http://download.microsoft.com/...) about AdvantureWorks Database. I have no ideas what it is all about and how to proceed to do the first sample in the 'master' database!!?? I am completely lost in this chapter and I do not know where and how to get my learning track right. Before I tried to do the Chapter 2, I touched the stuffs of Stored Proicedues in Microsoft Office Access 2003 a little bits and got lost there too.
Please help and advise.
Thanks,
Scott Chang

Scott Chang

__________________
Scott Chang

Hi Scott,

Were the build errors you got:
 "Msg 213, Level 16, State 1, Procedure sp_insertRecord, Line 1
Insert Error: Column name or number of supplied values does not match table definition."

If so then this was because on Step 1 of the Try It Out on page 36 we added a new column (field) to the Inventory table before you tried to run the Stored Procedures for the second time.

sp_updateRecord and sp_getRecord will work but not sp_insertRecord will fail.

Weeble


Growilng old is compulsory! Growing up is optional!