This is for MS SQL 2005: Anyone know why the first succeeds, then creating two of the same statement in succession fails? All the statements are exactly the same. Changing the double quote to two single quotes has the same effect.
sp
_
MSforeachdb @command1 = 'if (left("?", 2) = "p_
") begin; print "?"; end;';produces
p
_
NationalBrands
p_
NonBrand
p_
Database_
Name_
That_
Begins_
With_
P_
Underbar
but
sp
_
MSforeachdb @command1 = 'if (left("?", 2) = "p_
") begin; print "?"; end;';
sp_
MSforeachdb @command1 = 'if (left("?", 2) = "p_
") begin; print "?"; end;';produces
Msg 102, Level 15, State 1, Line 2 Incorrect syntax near 'sp_MSforeachdb'.