95.86.62.111/95.86.62.111.tar/95.86.62.111/SQLQuery1.sql

Text (UTF-16) | 2013-06-08 | 1.9 KB | 33 lines

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO


ALTER   PROCEDURE [dbo].[rk_IzmeniNacPlak]
    @Sifra_Nac        smallint,
    @ImeNac            char(30),
    @Fisc_Nacin        char(1),
    @Interna_Kart        smallint,
    @Gotovina        char(1),
    @Pec_Na_Prin        varchar(30),
    @Kopii_Na_Prin        smallint,
    @Obrazec_Prin        char(3),
    @MozePoz        char(1),
    @MozeNeg        char(1),
    @Poveke_Na_Ska    char(1),
    @Samo_Pomalo_Ska    char(1),
    @Sifra_Oe        smallint = Null,
    @Proc_Kamata        decimal(6,2)=NULL,
    @PDA_Ime        varchar(20),
    @Kto_Anal        char(10)=NULL
AS
    Update NacPlak
    Set ImeNac=@ImeNac, Fisc_Nacin=@Fisc_Nacin, Interna_Kart=@Interna_Kart, Gotovina=@Gotovina, Pec_Na_Prin=@Pec_Na_Prin, Kopii_Na_Prin=@Kopii_Na_Prin,
        Obrazec_Prin=@Obrazec_Prin, MozePoz=@MozePoz, MozeNeg=@MozeNeg, Poveke_Na_Ska=@Poveke_Na_Ska, Samo_Pomalo_Ska=@Samo_Pomalo_Ska,
        Sifra_Oe=@Sifra_Oe, Proc_Kamata=@Proc_Kamata, PDA_Ime = @PDA_Ime, Kto_Anal=@Kto_Anal
    Where Sifra_Nac=@Sifra_Nac
    Return @@ERROR