When outputing as a SQLString the string is not formatted correctly.
e.g.
SELECT [RowNum] ,
[SomeID] ,
[SomeCode]
FROM [TestData]

becomes :
SELECT @SQLString = N'SELECT [RowNum] ,' +
N' [SomeID] ,' +
N' [SomeCode]' +
N'FROM [TestData]'

which is equivalent to :
SELECT [RowNum] , [SomeID] , [SomeCode]FROM [TestData]
which does not execute as there is not space between the last selected column and FROM.

One solution would be to add a space before each ending quote or after each beginning quote by default.


Hope this example makes sense.If there is an alternative please let me know.

thanks.



Edited 2 time(s). Last edit at 03/02/2012 05:31PM by guidomarcel.

a, I see the issue. Will try to add a space before the FROM
Regards
Guido

will fix this with the next release

Can you also correct embedded quotes

SELECT a,'b',c FROM t

becomes
SELECT @sql = N'SELECT a' +
N' , 'b'' +
N' , c' +
N'FROM t'

Hi a,
as suggested by you, an additional space has beend adde to the end of the line. Available in online version 4.8.46

Thanks!