SELECT * (kako odvajati posle jedan po jedan zapis)

SELECT * (kako odvajati posle jedan po jedan zapis) 27.09.2006. u 14:32 · pre 244 meseca #1

Imam sledeći trigger:

Code:

CREATE TRIGGER [izmena kljuceva] ON [dbo].[temp1]
FOR INSERT
AS
DECLARE @settlementID CHAR(6), @jkdID CHAR(6), @naceID CHAR(5),  @ownershipID TINYINT, @formID INT, @agencyID CHAR(2), @registrantID UNIQUEIDENTIFIER

SELECT @registrantID = registrantID, @settlementID = settlementID, @jkdID = jkdID, @naceID = naceID, @ownershipID = ownershipID, @formID = formID, @agencyID = agencyID FROM INSERTED

-- PROVERA VREDNOSTI
IF NOT EXISTS (SELECT settlementID FROM settlementCounty WHERE settlementID = @settlementID)
BEGIN
    SET @settlementID = NULL
END

IF NOT EXISTS (SELECT jkdID FROM jkd WHERE jkdID = @jkdID)
BEGIN
    SET @jkdID = NULL
END

IF NOT EXISTS (SELECT naceID FROM nace WHERE naceID = @naceID)
BEGIN
    SET @naceID = NULL
END

IF NOT EXISTS (SELECT ownershipID FROM ownership WHERE ownershipID = @ownershipID)
BEGIN
    SET @ownershipID = NULL
END

IF NOT EXISTS (SELECT formID FROM companyForm WHERE formID = @formID)
BEGIN
    SET @formID = NULL
END

IF NOT EXISTS (SELECT agencyID FROM regAgency WHERE agencyID = @agencyID)
BEGIN
    SET @agencyID = NULL
END

UPDATE temp1
    SET settlementID = @settlementID, jkdID = @jkdID, naceID = @naceID, ownershipID = @ownershipID, formID = @formID, agencyID = @agencyID
    WHERE registrantID = @registrantID

DELETE FROM registrants WHERE registrantID = @registrantID

I sad hoću da uradim sledeće:

Code:

INSERT INTO temp1
SELECT * FROM registrants

Ali jednostavno ne radi! Kolega kaže da treba da mu zadam da uzima jedan po jedan zapis, pa će raditi. Jel ima neko ideju o čemu se radi?
Upućen sam na onaj FETCH NEXT RECORD... ali i dalje ne kapiram

p.s. It's kind of a EMERGENCY !!!

Potpis

Winners never quit, quitters never win.

Re: SELECT * (kako odvajati posle jedan po jedan zapis) 27.09.2006. u 15:12 · pre 244 meseca #2

Code:

INSERT INTO temp1
SELECT * FROM registrants

Ako ti je redosled kolona isti u temp1 i registrants ovo MORA da radi. Ako nisi siguran da li je redosled isti napisi kolone u upitu.

(napominjem da nisam detaljno gledao kod koji si poslao... to sigurno moze malo lepse da se napise...)

Potpis

Every hamster has his day.

Re: SELECT * (kako odvajati posle jedan po jedan zapis) 27.09.2006. u 15:45 · pre 244 meseca #3

Citat:

VerbatimBOT: Imam sledeći trigger:

Code:

UPDATE temp1
SET settlementID = @settlementID, jkdID = @jkdID, naceID = @naceID, ownershipID = @ownershipID, formID = @formID, agencyID = @agencyID
WHERE registrantID = @registrantID

DELETE FROM registrants WHERE registrantID = @registrantID

I sad hoću da uradim sledeće:

Code:

INSERT INTO temp1
SELECT * FROM registrants

Ali jednostavno ne radi! Kolega kaže da treba da mu zadam da uzima jedan po jedan zapis, pa će raditi. Jel ima neko ideju o čemu se radi?
Upućen sam na onaj FETCH NEXT RECORD... ali i dalje ne kapiram

p.s. It's kind of a EMERGENCY !!!

_{[Ovu poruku je menjao VerbatimBOT dana 27.09.2006. u 14:52 GMT+1]}

MISLIM da ovdje treba>
umesto

Code:

UPDATE temp1
SET settlementID = @settlementID, jkdID = @jkdID, naceID = @naceID, ownershipID = @ownershipID, formID = @formID, agencyID = @agencyID
WHERE registrantID = @registrantID

Code:

UPDATE registrants
SET settlementID = @settlementID, jkdID = @jkdID, naceID = @naceID, ownershipID = @ownershipID, formID = @formID, agencyID = @agencyID
WHERE registrantID = @registrantID

Dalje taj select bi trebao za radi,ovdje nema potrebe za fetchom.Mozda da malo bolje to opises.

Potpis

logic_rabbit (MCAD,MCSD,MCT,MCTS-
Windows development,MCPD)

Forum kao aplikacija na telefonu

Srodne teme