This depends on what driver you are using.
If using the M$ driver, they execute all statements via the stored prpocedure, but that is not the problem usually.
Problems happen when you have varchar fields but the driver wants to deal with all strings as unicode, which is why you see the N' before all of your strings.
The way to turn this off is to specify your ConnectionURL as such
I never tried the opposite though, making all of your fields nvarchar instead of varchar. That may work too.
I hope this helps...
Yes thats it, I could reproduce it. As you can see in the attached screen shot.
Statement 1 was executed with the parameter
Statement 2 was executed without that parameter.