Does SmartObject generate parameter binding for direct SQL execution to SQL Server?
If 100 different IDs are used is 1 query plan created or 100?
cmd.CommandText = "Select xmlname, xmlvalue FROM Process_XML.List WHERE ProcessInstanceID = ?"
Page 1 / 1
Good day
I reviewed you post and the problem seems to be caused by a syntax error in your "where" clause. See link below - the article attached should resolve your issue if not atleast clarify what's wrong with your SQL query -
https://en.wikipedia.org/wiki/Prepared_statement#frb-inline
regards
Az-R
Reply
View our Community Site Map
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.