Using Return we can not get/return varchar value Using Return we can not get/return multiple integer values. But it is possible via output parameters Nice explanation and valuable points for interview. But please explain in SQL server application, not in notepad
Just Parameter Count checks the number of characters in the Account number,if count matches to the account number characters and that account number given does not exit(no custmer with that account) then how the execution goes on
Sir i think its better if you give your example inside the sql server instead of writing note pad .
Nice explanation
Using Return we can not get/return varchar value
Using Return we can not get/return multiple integer values. But it is possible via output parameters
Nice explanation and valuable points for interview. But please explain in SQL server application, not in notepad
why do we use input parameters or output parameters? i mean what is the reason to use parameters....
Just Parameter Count checks the number of characters in the Account number,if count matches to the account number characters and that account number given does not exit(no custmer with that account) then how the execution goes on