May 3, 2010 at 1:32 pm
Anyone sees a problem with using the same colum to set the value to and use it as the qualifier? I ran the statement just fine with no error.
update table#1
set col1 = 'B'
where col1= 'A'
go
May 3, 2010 at 1:41 pm
That shouldn't be a problem.
please check out Identifiers http://msdn.microsoft.com/en-us/library/ms175874.aspx regarding your table name containing the #.
Avoid special chars in your object names or always use brackets ([ ]) with your object names
update [table#1] ...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
May 3, 2010 at 7:08 pm
Agreed. That's not really an issue.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply