Dear Anitha,

are the parameters param1 , param2 are used for the where conditions of select stmt. ???

if yes then u can try this ...

create proc sample1

@param1 as numeric(9,0), @param2 as...

Dear Pramod,

you can change the settings from query analyser window, by using the command, Tools ->Options -> Editor Tab. There you have options of default  tab spaces. Also check...