i know how to pass input parameter to stored procs.
why do we use output parameters in stored procs?
would anyone suggest an example for that kind of stored procs?
other question is about dynamic sql
can i able to use the where clause in dynamic sql?
eg: 'select gemName,gemType,State
from GEmTable where country=%A'
when i used dynamic sql in my scripts using where clause,i had an error message.
thank you very much for your time.