Debugging techniques

Hi,

Can anyone give me differnt options while debugging the query or the code.

What are the different ways to debug? How to check tables, variables, ..

objects associated?

A complete answer would be appreciable, If there is any article please give me

the link.

Full points will be given, If i got the desired help.

Thanks in advance.

shahid.