Viewing 5 posts - 1 through 5 (of 5 total)
"Update table1 set col1 = col1^1" is really great one as it is also work for table variable.
October 23, 2011 at 11:41 pm
I don't know this is the best solution or not, but you will get the results:
DECLARE @table as TABLE (col1 int, col2 varchar(5), col3 varchar(5))
INSERT INTO @table values (254689, 'AAAA',...
October 19, 2011 at 7:11 am
Thanks once again for reply… Rozema, I got an idea from your example.
Once again I am putting my question for better understanding. See I have a table which doesn’t...
September 27, 2011 at 11:11 pm
Thanks for your reply and I got the solution.
September 27, 2011 at 5:41 am
Viewing 5 posts - 1 through 5 (of 5 total)