How to handle exception in stored procedure in sql

Question

Hi frnds Please give the example for exception handling in stored procedure.which I can explain an interview. I went for the interview they asked me this qus I said to them and like try catch ,but they didn't satisfied.please give me example

Answer 1

i also having that issue

ito solve this i have coded my Own Encryption and decryption Function

and Stored Setting like

below

             <Settings>
            <setting name="server" serializeAs="String">
                <value>75ƒ105ƒ114ƒ116ƒ97ƒ110ƒ45ƒ80ƒ67ƒ92ƒ83ƒ81ƒ76ƒ69ƒ88ƒ80ƒ82ƒ69ƒ83ƒ83ƒ</value>
            </setting>
            <setting name="username" serializeAs="String">
                <value>115ƒ97ƒ</value>
            </setting>
            <setting name="password" serializeAs="String">
                <value>49ƒ50ƒ51ƒ52ƒ53ƒ</value>
            </setting>
            <setting name="databasename" serializeAs="String">
                <value>103ƒ119ƒ101ƒ100ƒ99ƒ</value>
            </setting>
            <setting name="gwedcConStr" serializeAs="String">
                <value>68ƒ97ƒ116ƒ97ƒ32ƒ83ƒ111ƒ117ƒ114ƒ99ƒ101ƒ61ƒ75ƒ105ƒ114ƒ116ƒ97ƒ110ƒ45ƒ80ƒ67ƒ92ƒ83ƒ81ƒ76ƒ69ƒ88ƒ80ƒ82ƒ69ƒ83ƒ83ƒ59ƒ85ƒ115ƒ101ƒ114ƒ32ƒ73ƒ100ƒ61ƒ115ƒ97ƒ59ƒ80ƒ97ƒ115ƒ115ƒ119ƒ111ƒ114ƒ100ƒ61ƒ49ƒ50ƒ51ƒ52ƒ53ƒ</value>
            </setting>
            <setting name="LogedUser" serializeAs="String">
                <value />
            </setting>
            <setting name="adminuser" serializeAs="String">
                <value>97ƒ100ƒ109ƒ105ƒ110ƒ</value>
            </setting>
            <setting name="adminpass" serializeAs="String">
                <value>49ƒ50ƒ51ƒ52ƒ53ƒ</value>
            </setting>
        </Settings>
    </userSettings>
        
    

if Anyone Have better Idea Tell me too .....