This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Parameters to see @ProdNumber, @Desc, @UnitPrice. 4. Right click Add_Product and select Execute Stored Procedure. When window appears asking for data, enter values into table. 5. Click OK … “ Query Executed Successfully ” should appear at bottom of Execute pane. 6. Verify that new Product was added by running a Select query on Product table. 7. ALTERNATE method of executing procedure: In new Query window, enter following and press Execute to run. execute Add_Product '31235', 'Second product', 1.45...
View Full Document
- Spring '08
- @, Stored procedure, Click Execute button, Execute Stored Procedure, 31235