Select … | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Select …

Maybe this question is not related to sql tuning, but i need help and i have not found
better forum then this. select @ciag = ‘update ##temp1 SET M’+cast (@id as varchar)+’=’
select @ciag = @ciag + ‘"’+cast(@pr as varchar)+ ‘-‘+cast (@cn as varchar)+’" where id=’+cast (@post as varchar) in result i wan to have sth like this:
update ##temp1 SET M1="23.45-56.67" where id=5 i got error: Ivalid Column name 23.45-56.67 M1 field is varchar field please help me ….
Did you try, ‘ instead "? I mean SET M1=’…..’ Luis Martin
Moderator One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
ehhh yes i entered char(39) = ‘ on the left end right side …. and now works…
Thank you very much