This workshop will help reinforce the concepts you've learned in today's lesson. Answers can be found in Appendix A.
Specify a SQL statement to create an empty stored procedure (one that doesn't execute any SQL statement) that accepts one input parameter and one output parameter of your choice.
What are the four parameter directions?
True or false: You use output parameters if you want to return multiple rows of data.
Will the following code work?
Response.Write("ID = " & objCmd.Parameters("@ID"). _ Value.ToString()) objReader.Close()
What's the difference between XPathNavigator and XmlDocument?
What is an XSL stylesheet used for, and how is it related to XPath queries?
How do you return data from an XSL transform with XmlReader? With XmlTextWriter?
Create a stored procedure that inserts a new row into your tblUsers table using parameters. Build an ASP.NET page that allows users to enter this data, and execute this procedure with parameters.