Hi all,
I managed to finish the Try It Out stuff in Chapters 4 (VBExpress)and 5 (VWDExpress). Now I came back to do the SSMS-EE Try It Out stuff in Chapter 2 to understand the SQL Server 2005 Express programming. I am doing the "Creating and Using Stored Procedures" on Pages 34-35. I copied the code statements of Steps 1 thru 6 of Try It Out on Pages 34-35 exactly. The execution of the program went well until Step 6: the first code statement of Step 6 gave me a weird BUILD error that said the order of executing the first and second code statements in Step 6 should be reversed!!!??? I do not know how to correct this problem. Any one has this problem? Please help and advise.
Thanks in advance,
Scott Chang

Scott Chang

__________________
Scott Chang

The actual error messages are:
Msg 134, Level 15, State 1, Procedure sp_insertRecord, Line 7
The variable name '@procID' has already been declared. Variable names must be unique within a query batch or stored procedure.
Msg 134, Level 15, State 1, Procedure sp_insertRecord, Line 9
The variable name '@procID' has already been declared. Variable names must be unique within a query batch or stored procedure.
Msg 134, Level 15, State 1, Procedure sp_insertRecord, Line 10
The variable name '@procID' has already been declared. Variable names must be unique within a query batch or stored procedure.
Msg 102, Level 15, State 1, Procedure sp_insertRecord, Line 13
Incorrect syntax near 'EXE'.
======================================
Any insights?

Scott Chang