Comments by DeepikaSrivastava (Top 6 by date)

Thanks for answering..
but i want output like
1. use group by clause
2.no row are inserted in table
3. select * from tablename / output- no row selected.
4.then run SELECT ISNULL(Sum(SomeValue),0) FROM TestSum group by somevalue,testid;
this displays blank but i want zero

Thanks a Lot E.F Nijboer. ,but the above link is not opening at my end, can u please elaborate here in words.

yes,
full exception which is showing for above application is this:
Communication Exception was unhandled by user code:
The remote server returned an error: NotFound.

okh, Thanks for above solution, we can not change order of columns permanently. i want ALTER sql for it to make changes permanently.