In T-SQL debugging, "Step Into" behaves like "Step Over."

Question

In T-SQL debugging, "Step Into" behaves like "Step Over."

Jungsooooo 0

visual studio 2022 (17.11.5)
Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64) Oct 8 2022 05:58:25 Copyright (C) 2022 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Enterprise 10.0 <X64> (Build 22631: ) (Hypervisor)

During the debugging process of a procedure, when using Step Into on the EXEC procedure statement, it behaves like Step Over. However, the results (e.g., return_value) are displayed correctly.

What could be the reason for this behavior, and how can it be resolved?

User's image

On the 6th line, when I use Step Into (F11), [usp_user_insert] does not open, and it skips directly to:

SELECT @return_value as 'Return Value'.

Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2024-11-22T22:08:18.9+00:00

I never use the debugger, do I don't know. I always work with debug PRINT and SELECT. Given the nature of SQL, a traditional debugger is less useful. So my recommendation is to not spend much time on getting this to work.

Another note: you are running the release version of SQL 2022. You should download the most recent Cumulative Update to get access to many bug fixes and enhancements.
Jungsooooo 0 Reputation points

2024-11-26T12:19:25.6833333+00:00

Thank you. I should do the same

1 answer

Your answer

Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2024-11-22T22:08:18.9+00:00

I never use the debugger, do I don't know. I always work with debug PRINT and SELECT. Given the nature of SQL, a traditional debugger is less useful. So my recommendation is to not spend much time on getting this to work.

Another note: you are running the release version of SQL 2022. You should download the most recent Cumulative Update to get access to many bug fixes and enhancements.
Jungsooooo 0 Reputation points

2024-11-26T12:19:25.6833333+00:00

Thank you. I should do the same

Answer 1

LiHongMSFT-4306 31,566

Hi @Jungsooooo

To debug Stored Procedure, please follow the steps here: Debug stored procedures.

Best regards,

Cosmog

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Jungsooooo 0 Reputation points

2024-11-26T12:16:53.9733333+00:00

Thank you, but I'm already doing this.

Share via

In T-SQL debugging, "Step Into" behaves like "Step Over."

1 answer

Your answer