DEFINITIONS

Definitions More Info.
Definition ID951
TitleSQL
CategoryNOTES
Definitionupdate islemini loglama
Definition Descriptionhttps://stackoverflow.com/questions/1610509/getting-the-id-of-a-row-i-updated-in-sql-server

--DROP TABLE AdayrefNumber
CREATE TABLE AdayrefNumber(
ID INT IDENTITY(1,1) PRIMARY KEY,
AdayRefNumber INT,
Dummyid decimal(18,0),
RecordDate datetime DEFAULT (getdate()))

UPDATE AdayLogDB
SET PostingDate=getdate()
OUTPUT inserted.AdayRefNumber,inserted.Dummyid
INTO AdayrefNumber (AdayRefNumber,Dummyid)
WHERE AdayRefNumber IN (9199311,
9700996,
9700826,
6215274)
RecordBycunay
Record Date16-07-2019 18:22:09
Düzenle
Kopyala
Sil