Welcome to Sign in | Help

valoarea unui parametru si breakpoint

  •  11-19-2007, 3:13 PM

    valoarea unui parametru si breakpoint

    am o procedura stocata pe care o apelez din asp.net unde am un grid

    problema mea e ca nu stiu cum imi trimite parametrul adica ce tipp il face

    procedura arata asa

    set ANSI_NULLS ON
    set QUOTED_IDENTIFIER ON
    go

    ALTER proc [dbo].[sp_up_masini_Casco]
    @id numeric(18,0), @id_masina numeric(18,0), @data_asig1 nvarchar(20),
    @data_asig datetime,@data_exp datetime,
    @data_exp1 nvarchar(20),
    @suma nvarchar(18), @val nchar(10), @prima numeric(18,2), @soc_asig
    nvarchar(10), @procent numeric(18,2)
    as

    set nocount on
    declare @tableOneCount int
    declare @sum nvarchar(20)
    declare @prim nvarchar(20)
    declare @proc nvarchar(20)


    begin
        -- Get the number of rows from the first table
        SELECT @tableOneCount = (SELECT COUNT(*) FROM tblMasinaCASCO
                             WHERE id_masina=@id)
    -- set @sum=substring(@suma,1,len(@suma)-3)+'.'+substring(@suma,len(@suma)-1,len(@suma))


    if @tableOneCount=0

    insert into tblMasinaCASCO(id_masina,data_asig,data_exp,suma,val,prima,soc_asig,procent)
      values(@id,convert(datetime,@data_asig1, 104),convert(datetime,@data_exp1,104),@sum,@val,@prim,@soc_asig,@proc)
     
    else
     
       
        update tblMasinaCASCO set id_masina =@id ,
            data_asig = convert(datetime,@data_asig1, 104),data_exp = convert(datetime,@data_exp1,104),
            suma = substring(@suma,1,len(@suma)-3)+'.'+substring(@suma,len(@suma)-1,len(@suma)),val=@val,
            soc_asig = @soc_asig,procent=@proc
           where  id_masina = @id
     
    end

     

    cum pot adauga un breakpoint? sau cum pot afla cand o valoarea parametrului suma? 

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems