Logo SQLinForm

 

Martin
Dynamic sql does not work
April 25, 2012 02:34PM
Formatting dynamic sql doesn't work with embedded single quotes

Unformatted: SELECT 'str' AS [Value]
Expected: SELECT @sql=N'SELECT ''str'' AS [Value]'
sqlinform: SELECT @sql=N'SELECT 'str' AS [Value]'

It also doesn't work the other way

Unformatted: SELECT @sql='SELECT ''str'' AS [Value]'
Expected: SELECT 'str' AS [Value]
sqlinform: SELECT str AS [Value]
Re: Dynamic sql does not work
June 15, 2012 03:41PM
Hi Martin,
thanks for your feedback. Will try to add this feature soon.
Regards
Guido
Author:

Your Email (Optional):


Subject:


Spam prevention:
Please, solve the mathematical question and enter the answer in the input field below. This is for blocking bots that try to post this form automatically.
Question: how much is 4 plus 4?
Message: