Output parameters with SQL Stored Procs

hi,
when u want tu use output parameter u have to declare it as out , andin sored procedure u have to declare the prameter in which u are returning value as out. if it is not clear u can post a message on user name 'shetu' , send the stored proc and i will send u the code for getting the value . if possible also give the code written in vb to fetch the out para value.

shweta