Debugging: Monitor dynamic string construction

Posted on 2005-04-21
Medium Priority
Last Modified: 2010-03-19
I'm forced into some relatively complex dynamic string construction situation where just knowing the arugements set from the webpage isn't enough. If i were able to simply test in QA i'd just 'print mySQL' but this is ASP.NET-based and i'm depending on Profiler and I don't have enough experience with that tool to control it that well. I can see the SET commands executing but not th actual value that results.

I'm close to creating a scratch table to INSERT the generated strings before they execute but that seems ...umm...inelegant.
Question by:juststeve
1 Comment
LVL 28

Accepted Solution

rafrancisco earned 1000 total points
ID: 13835907
Aside from what you're already thinking of, that is inserting into a table before executing it, you can also create a stored procedure that will accept as parameter your dynamic statement and insert this to a table before executing it.

But the concept is the same, you still have to write it on a table for you to know the full statement it is executing.  I can't think of any other way.

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question