Debugging SqlCommand

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm using a SqlCommand with parametrized sql like "select @field1, @field2,
....".
Is possible to see the sql sentence with parameters VALUES, not "@field1,
...." ?
It would be great for debugging.

Thanks.
 
Hi Vipper,

Use Sql Profiler and you'll be able to see what's actually being executed on
the sql server side.

Hope this helps
 
Generally, you cannot parameterize object names.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Null Value to SQL Server 5
parse parameters from sql statement 8
Is there a method to convert SqlCommand text 2
Sqladapter Insert 1
most puzzle question 1 about sqlparameters.My question is following the ///.thank you. 2
SQL and leading zeros 1
Very Strange: field value is not updated if you try to set it to its default value 1
sqlcommand question 2

Back
Top