Proceduce e.g.1

Create Procedure Proc_D_TB_CCY

(@CcyCde Varchar(20)) 

AS

BEGIN

           DELETE FROM TB_Ccy WHERE  CcyCde=@CcyCde

           AND @CcyCde NOT IN(

           SELECT DISTINCT CcyCde FROM TB_Sec WHERE CcyCde=@CcyCde )

END

-----------------------------------------------------------------------------------------

SqlCommand deleteCmd = new SqlCommand();
                deleteCmd.CommandText = "Proc_D_TB_CCY";
                deleteCmd.CommandType = CommandType.StoredProcedure;
                deleteCmd.Connection = sqlConn;
                deleteCmd.Parameters.Add("@CcyCde", SqlDbType.VarChar, CommonDef.FD_LEN_CD, "CcyCde");

                SqlHelper.UpdateDataset(insertCmd, deleteCmd, updateCmd, ds, ds.TB_Ccy.TableName);