Changes between Version 2 and Version 3 of UseCaseNovaNaracka

Timestamp:

02/20/24 16:30:37 (3 months ago)

Author:

201156

Comment:

--

UseCaseNovaNaracka

@@ -55 +55 @@
 ''Креирање Нарачка''
 
+
 DECLARE @Kolicina INT;
 DECLARE @DatumStart DATE;
@@ -63 +64 @@
 VALUES (@Kolicina, GETDATE(), 'YourOpis'); 
 
+
 DECLARE @NarackaID INT;
 SET @NarackaID = SCOPE_IDENTITY();
+
 
 DECLARE @FirmaID INT;
 SET @FirmaID = (SELECT FirmaID FROM Firma WHERE Naziv = @FirmaNaziv);
 
+
 DECLARE @ArtiklID INT;
 SET @ArtiklID = (SELECT ArtiklID FROM Artikl WHERE Naziv = @ArtiklNaziv);
+
 
 INSERT INTO Naracka_Artikl (NarackaID, ArtiklID)
 VALUES (@NarackaID, @ArtiklID);
 
+
 INSERT INTO Naracka_Firma (NarackaID, FirmaID)
 VALUES (@NarackaID, @FirmaID);
+
 
 INSERT INTO Naracka_IzrabotkaPlan (NarackaID, DatumStart, DatumEnd)