SQL querry typing in putty


#1

Hi I am trying to type the sql query in Putty server but unable to write the full query .
for example my query is

INNER JOIN [CMDBConfigItemRel] ON [VGE_LocalPortfolio.CIID] = [CMDBConfigItemRel.FromID]

and the Robot typing from above query is only INNER JOIN ON =
what ever inside the braces is not typing
not sure yet why it is typing only that.
any advise would be very helpful

Thank you
Vijay


#2

Square brackets are used to indicate special keys.
You can escape them by putting double brackets, f.e. like this:
yourString.Replace("[", "[[")
(there’s no need to escape the closing brackets)


Type into activity omitting square brackets and contents within it
#3

Thank you Andrzej
I have replaced my string