Day 17
Quiz
| 1: | What is a breakpoint? |
| A1: | A breakpoint is a method of setting automatic stops within a stored procedure to halt the execution of the procedure at a particular statement in order to debug a problem. |
| 2: | What is being displayed in the Local Variables pane? |
| A2: | The Local Variables pane displays all the parameters that were passed to the procedure as well as any variables that you declared within the procedure. |
| 3: | How can comments help in the testing process? |
| A3: | You can use comments to prevent sections of SQL code from being executed when testing the procedure. Comments also enable you to leave testing code, such as PRINT statements and parameter assignment statements, in the procedure without concern that they will be executed accidentally. ... |
Get Sams Teach Yourself Transact-SQL in 21 Days, Second Edition 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.
