Update openquery variable

Could you please elaboreate a bit on your constraints? Usually, we need to use dynamic SQL to pass variables to a linked server query. Sign in. United States English. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. You must be logged in to reply to this topic. Login to reply. July 12, at pm I have the following openquery I need to set a variable for to process.

That's scary, we even picked the same alias and variable names :blink: There are no special teachers of virtue, because virtue is taught by the whole community. March 19, at am March 20, at am Learn more.

Update OpenQuery with parameters Ask Question. Asked 6 years, 9 months ago. Active 6 years, 9 months ago. Viewed 6k times. Improve this question. Community Bot 1 1 1 silver badge. Gordon Barclay Gordon Barclay 13 1 1 silver badge 6 6 bronze badges. I know I must be missing something obvious but cannot see what it is. You need another ' so that it looks like 'ES''.

Also, the end should look like '', not '". Confused Mark, you said : Also, the end should look like '', not '", but earlier said Looks like you're just missing a quote at the end after '', which one is it? Sorry, that should have been single quote, not quote. Add a comment. Active Oldest Votes. Improve this answer. Mark Leiber Mark Leiber 3, 2 2 gold badges 11 11 silver badges 22 22 bronze badges.