Skip to Main Content
Visual Studio Hacks
book

Visual Studio Hacks

by James Avery
March 2005
Intermediate to advanced content levelIntermediate to advanced
304 pages
19h 23m
English
O'Reilly Media, Inc.
Content preview from Visual Studio Hacks
Debug SQL Server #40
Chapter 5, Debugging
|
157
HACK
Web applications are constantly trying to behave more like their Windows
client brethren, and this means more and more client-side scripting. The
ability to debug client-side script can save tremendous amounts of time
when trying to find bugs in it or when simply trying to understand the flow
of the application.
HACK
#40
Debug SQL Server Hack #40
Learn how to use Visual Studio to debug Transact SQL stored procedures or
functions.
SQL statements can be difficult to diagnose and debug. SQL Server does not
include any default way to debug and step through a stored procedure, but
Visual Studio does. Using the Server Explorer, you can step through the exe-
cution of a stored procedure or function right inside of Visual Studio. The
first step is to open the Server Explorer and create a data connection to your
database
[Hack #74].
You will then see the stored procedures and functions of your database
listed in the Server Explorer; these objects for the Northwind database are
shown in Figure 5-21.
From the Server Explorer, you can right-click on a stored procedure or func-
tion and you will see a menu item named Step Into Stored Procedure, as
shown in Figure 5-22.
When you select Step Into Stored Procedure, you will see the Run Stored
Procedure dialog that is shown in Figure 5-23.
Figure 5-20. Debugging client-side script
158
|
Chapter 5, Debugging
#40 Debug SQL Server ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft Visual Studio 2015 Unleashed, Third Edition

Microsoft Visual Studio 2015 Unleashed, Third Edition

Mike Snell, Lars Powers
.Net Framework Essentials

.Net Framework Essentials

Thuan L. Thai, Hoang Lam
C# 5.0 Unleashed

C# 5.0 Unleashed

Bart De Smet
Programming .NET Security

Programming .NET Security

Adam Freeman, Allen Jones

Publisher Resources

ISBN: 0596008473Errata Page