User Tools

Site Tools


windows:sqlserver

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
windows:sqlserver [2015/03/11 15:24] – [query log in sql server] adminwindows:sqlserver [2022/10/29 16:15] (current) – external edit 127.0.0.1
Line 45: Line 45:
 ==== The actual stored procedure line number from an error message ==== ==== The actual stored procedure line number from an error message ====
 Error line numbers may not match the number returned in the error always, this is because when **the SQL server executes a stored proc, it has its own compilation & execution methodology**, so the line numbers vary based on the execution order it takes Error line numbers may not match the number returned in the error always, this is because when **the SQL server executes a stored proc, it has its own compilation & execution methodology**, so the line numbers vary based on the execution order it takes
 +==== Debug stored procedure with break point ====
windows/sqlserver.1426087499.txt.gz · Last modified: 2022/10/29 16:15 (external edit)