How to get the identity of an inserted row? – Stack Overflow

August 28, 2025

Most of the time this works fine, but sometimes a trigger will go and insert a new row that you don’t know about, and you’ll get the ID from this new row, instead of the one you want SCOPE_IDENTITY() solves this problem. It returns the id of the last thing that you inserted in the SQL code you sent to the database.

How to get the identity of an inserted row? – Stack Overflow <body> <h1> Array ( [0] => gow to get the identity of an inserted row? – stack overflow [1] => bow to get the identity of an inserted row? – stack overflow [2] => now to get the identity of an inserted row? – stack overflow [3] => jow to get the identity of an inserted row? – stack overflow [4] => uow to get the identity of an inserted row? – stack overflow [5] => yow to get the identity of an inserted row? – stack overflow [6] => hiw to get the identity of an inserted row? – stack overflow [7] => hkw to get the identity of an inserted row? – stack overflow [8] => hlw to get the identity of an inserted row? – stack overflow [9] => hpw to get the identity of an inserted row? – stack overflow [10] => h0w to get the identity of an inserted row? – stack overflow [11] => h9w to get the identity of an inserted row? – stack overflow [12] => hoq to get the identity of an inserted row? – stack overflow [13] => hoa to get the identity of an inserted row? – stack overflow [14] => hos to get the identity of an inserted row? – stack overflow [15] => hoe to get the identity of an inserted row? – stack overflow [16] => ho3 to get the identity of an inserted row? – stack overflow [17] => ho2 to get the identity of an inserted row? – stack overflow [18] => how ro get the identity of an inserted row? – stack overflow [19] => how fo get the identity of an inserted row? – stack overflow [20] => how go get the identity of an inserted row? – stack overflow [21] => how yo get the identity of an inserted row? – stack overflow [22] => how 6o get the identity of an inserted row? – stack overflow [23] => how 5o get the identity of an inserted row? – stack overflow [24] => how ti get the identity of an inserted row? – stack overflow [25] => how tk get the identity of an inserted row? – stack overflow [26] => how tl get the identity of an inserted row? – stack overflow [27] => how tp get the identity of an inserted row? – stack overflow [28] => how t0 get the identity of an inserted row? – stack overflow [29] => how t9 get the identity of an inserted row? – stack overflow [30] => how to fet the identity of an inserted row? – stack overflow [31] => how to vet the identity of an inserted row? – stack overflow [32] => how to bet the identity of an inserted row? – stack overflow [33] => how to het the identity of an inserted row? – stack overflow [34] => how to yet the identity of an inserted row? – stack overflow [35] => how to tet the identity of an inserted row? – stack overflow [36] => how to gwt the identity of an inserted row? – stack overflow [37] => how to gst the identity of an inserted row? – stack overflow [38] => how to gdt the identity of an inserted row? – stack overflow [39] => how to grt the identity of an inserted row? – stack overflow [40] => how to g4t the identity of an inserted row? – stack overflow [41] => how to g3t the identity of an inserted row? – stack overflow [42] => how to ger the identity of an inserted row? – stack overflow [43] => how to gef the identity of an inserted row? – stack overflow [44] => how to geg the identity of an inserted row? – stack overflow [45] => how to gey the identity of an inserted row? – stack overflow [46] => how to ge6 the identity of an inserted row? – stack overflow [47] => how to ge5 the identity of an inserted row? – stack overflow [48] => how to get rhe identity of an inserted row? – stack overflow [49] => how to get fhe identity of an inserted row? – stack overflow [50] => how to get ghe identity of an inserted row? – stack overflow [51] => how to get yhe identity of an inserted row? – stack overflow [52] => how to get 6he identity of an inserted row? – stack overflow [53] => how to get 5he identity of an inserted row? – stack overflow [54] => how to get tge identity of an inserted row? – stack overflow [55] => how to get tbe identity of an inserted row? – stack overflow [56] => how to get tne identity of an inserted row? – stack overflow [57] => how to get tje identity of an inserted row? – stack overflow [58] => how to get tue identity of an inserted row? – stack overflow [59] => how to get tye identity of an inserted row? – stack overflow [60] => how to get thw identity of an inserted row? – stack overflow [61] => how to get ths identity of an inserted row? – stack overflow [62] => how to get thd identity of an inserted row? – stack overflow [63] => how to get thr identity of an inserted row? – stack overflow [64] => how to get th4 identity of an inserted row? – stack overflow [65] => how to get th3 identity of an inserted row? – stack overflow [66] => how to get the udentity of an inserted row? – stack overflow [67] => how to get the jdentity of an inserted row? – stack overflow [68] => how to get the kdentity of an inserted row? – stack overflow [69] => how to get the odentity of an inserted row? – stack overflow [70] => how to get the 9dentity of an inserted row? – stack overflow [71] => how to get the 8dentity of an inserted row? – stack overflow [72] => how to get the isentity of an inserted row? – stack overflow [73] => how to get the ixentity of an inserted row? – stack overflow [74] => how to get the icentity of an inserted row? – stack overflow [75] => how to get the ifentity of an inserted row? – stack overflow [76] => how to get the irentity of an inserted row? – stack overflow [77] => how to get the ieentity of an inserted row? – stack overflow [78] => how to get the idwntity of an inserted row? – stack overflow [79] => how to get the idsntity of an inserted row? – stack overflow [80] => how to get the iddntity of an inserted row? – stack overflow [81] => how to get the idrntity of an inserted row? – stack overflow [82] => how to get the id4ntity of an inserted row? – stack overflow [83] => how to get the id3ntity of an inserted row? – stack overflow [84] => how to get the idebtity of an inserted row? – stack overflow [85] => how to get the idemtity of an inserted row? – stack overflow [86] => how to get the idejtity of an inserted row? – stack overflow [87] => how to get the idehtity of an inserted row? – stack overflow [88] => how to get the idenrity of an inserted row? – stack overflow [89] => how to get the idenfity of an inserted row? – stack overflow [90] => how to get the idengity of an inserted row? – stack overflow [91] => how to get the idenyity of an inserted row? – stack overflow [92] => how to get the iden6ity of an inserted row? – stack overflow [93] => how to get the iden5ity of an inserted row? – stack overflow [94] => how to get the identuty of an inserted row? – stack overflow [95] => how to get the identjty of an inserted row? – stack overflow [96] => how to get the identkty of an inserted row? – stack overflow [97] => how to get the identoty of an inserted row? – stack overflow [98] => how to get the ident9ty of an inserted row? – stack overflow [99] => how to get the ident8ty of an inserted row? – stack overflow [100] => how to get the identiry of an inserted row? – stack overflow [101] => how to get the identify of an inserted row? – stack overflow [102] => how to get the identigy of an inserted row? – stack overflow [103] => how to get the identiyy of an inserted row? – stack overflow [104] => how to get the identi6y of an inserted row? – stack overflow [105] => how to get the identi5y of an inserted row? – stack overflow [106] => how to get the identitt of an inserted row? – stack overflow [107] => how to get the identitg of an inserted row? – stack overflow [108] => how to get the identith of an inserted row? – stack overflow [109] => how to get the identitu of an inserted row? – stack overflow [110] => how to get the identit7 of an inserted row? – stack overflow [111] => how to get the identit6 of an inserted row? – stack overflow [112] => how to get the identity if an inserted row? – stack overflow [113] => how to get the identity kf an inserted row? – stack overflow [114] => how to get the identity lf an inserted row? – stack overflow [115] => how to get the identity pf an inserted row? – stack overflow [116] => how to get the identity 0f an inserted row? – stack overflow [117] => how to get the identity 9f an inserted row? – stack overflow [118] => how to get the identity od an inserted row? – stack overflow [119] => how to get the identity oc an inserted row? – stack overflow [120] => how to get the identity ov an inserted row? – stack overflow [121] => how to get the identity og an inserted row? – stack overflow [122] => how to get the identity ot an inserted row? – stack overflow [123] => how to get the identity or an inserted row? – stack overflow [124] => how to get the identity of zn inserted row? – stack overflow [125] => how to get the identity of sn inserted row? – stack overflow [126] => how to get the identity of wn inserted row? – stack overflow [127] => how to get the identity of qn inserted row? – stack overflow [128] => how to get the identity of ab inserted row? – stack overflow [129] => how to get the identity of am inserted row? – stack overflow [130] => how to get the identity of aj inserted row? – stack overflow [131] => how to get the identity of ah inserted row? – stack overflow [132] => how to get the identity of an unserted row? – stack overflow [133] => how to get the identity of an jnserted row? – stack overflow [134] => how to get the identity of an knserted row? – stack overflow [135] => how to get the identity of an onserted row? – stack overflow [136] => how to get the identity of an 9nserted row? – stack overflow [137] => how to get the identity of an 8nserted row? – stack overflow [138] => how to get the identity of an ibserted row? – stack overflow [139] => how to get the identity of an imserted row? – stack overflow [140] => how to get the identity of an ijserted row? – stack overflow [141] => how to get the identity of an ihserted row? – stack overflow [142] => how to get the identity of an inaerted row? – stack overflow [143] => how to get the identity of an inzerted row? – stack overflow [144] => how to get the identity of an inxerted row? – stack overflow [145] => how to get the identity of an inderted row? – stack overflow [146] => how to get the identity of an ineerted row? – stack overflow [147] => how to get the identity of an inwerted row? – stack overflow [148] => how to get the identity of an inswrted row? – stack overflow [149] => how to get the identity of an inssrted row? – stack overflow [150] => how to get the identity of an insdrted row? – stack overflow [151] => how to get the identity of an insrrted row? – stack overflow [152] => how to get the identity of an ins4rted row? – stack overflow [153] => how to get the identity of an ins3rted row? – stack overflow [154] => how to get the identity of an inseeted row? – stack overflow [155] => how to get the identity of an insedted row? – stack overflow [156] => how to get the identity of an insefted row? – stack overflow [157] => how to get the identity of an insetted row? – stack overflow [158] => how to get the identity of an inse5ted row? – stack overflow [159] => how to get the identity of an inse4ted row? – stack overflow [160] => how to get the identity of an inserred row? – stack overflow [161] => how to get the identity of an inserfed row? – stack overflow [162] => how to get the identity of an inserged row? – stack overflow [163] => how to get the identity of an inseryed row? – stack overflow [164] => how to get the identity of an inser6ed row? – stack overflow [165] => how to get the identity of an inser5ed row? – stack overflow [166] => how to get the identity of an insertwd row? – stack overflow [167] => how to get the identity of an insertsd row? – stack overflow [168] => how to get the identity of an insertdd row? – stack overflow [169] => how to get the identity of an insertrd row? – stack overflow [170] => how to get the identity of an insert4d row? – stack overflow [171] => how to get the identity of an insert3d row? – stack overflow [172] => how to get the identity of an insertes row? – stack overflow [173] => how to get the identity of an insertex row? – stack overflow [174] => how to get the identity of an insertec row? – stack overflow [175] => how to get the identity of an insertef row? – stack overflow [176] => how to get the identity of an inserter row? – stack overflow [177] => how to get the identity of an insertee row? – stack overflow [178] => how to get the identity of an inserted eow? – stack overflow [179] => how to get the identity of an inserted dow? – stack overflow [180] => how to get the identity of an inserted fow? – stack overflow [181] => how to get the identity of an inserted tow? – stack overflow [182] => how to get the identity of an inserted 5ow? – stack overflow [183] => how to get the identity of an inserted 4ow? – stack overflow [184] => how to get the identity of an inserted riw? – stack overflow [185] => how to get the identity of an inserted rkw? – stack overflow [186] => how to get the identity of an inserted rlw? – stack overflow [187] => how to get the identity of an inserted rpw? – stack overflow [188] => how to get the identity of an inserted r0w? – stack overflow [189] => how to get the identity of an inserted r9w? – stack overflow [190] => how to get the identity of an inserted roq? – stack overflow [191] => how to get the identity of an inserted roa? – stack overflow [192] => how to get the identity of an inserted ros? – stack overflow [193] => how to get the identity of an inserted roe? – stack overflow [194] => how to get the identity of an inserted ro3? – stack overflow [195] => how to get the identity of an inserted ro2? – stack overflow [196] => how to get the identity of an inserted row? ᰫ stack overflow [197] => how to get the identity of an inserted row? &#u211; stack overflow [198] => how to get the identity of an inserted row? &#i211; stack overflow [199] => how to get the identity of an inserted row? ⏻ stack overflow [200] => how to get the identity of an inserted row? ᾯ stack overflow [201] => how to get the identity of an inserted row? &#8q11; stack overflow [202] => how to get the identity of an inserted row? &#8w11; stack overflow [203] => how to get the identity of an inserted row? ⁷ stack overflow [204] => how to get the identity of an inserted row? ” stack overflow [205] => how to get the identity of an inserted row? &#82q1; stack overflow [206] => how to get the identity of an inserted row? — stack overflow [207] => how to get the identity of an inserted row? &#821q; stack overflow [208] => how to get the identity of an inserted row? – atack overflow [209] => how to get the identity of an inserted row? – ztack overflow [210] => how to get the identity of an inserted row? – xtack overflow [211] => how to get the identity of an inserted row? – dtack overflow [212] => how to get the identity of an inserted row? – etack overflow [213] => how to get the identity of an inserted row? – wtack overflow [214] => how to get the identity of an inserted row? – srack overflow [215] => how to get the identity of an inserted row? – sfack overflow [216] => how to get the identity of an inserted row? – sgack overflow [217] => how to get the identity of an inserted row? – syack overflow [218] => how to get the identity of an inserted row? – s6ack overflow [219] => how to get the identity of an inserted row? – s5ack overflow [220] => how to get the identity of an inserted row? – stzck overflow [221] => how to get the identity of an inserted row? – stsck overflow [222] => how to get the identity of an inserted row? – stwck overflow [223] => how to get the identity of an inserted row? – stqck overflow [224] => how to get the identity of an inserted row? – staxk overflow [225] => how to get the identity of an inserted row? – stavk overflow [226] => how to get the identity of an inserted row? – stafk overflow [227] => how to get the identity of an inserted row? – stadk overflow [228] => how to get the identity of an inserted row? – stacj overflow [229] => how to get the identity of an inserted row? – stacm overflow [230] => how to get the identity of an inserted row? – stacl overflow [231] => how to get the identity of an inserted row? – staco overflow [232] => how to get the identity of an inserted row? – staci overflow [233] => how to get the identity of an inserted row? – stack iverflow [234] => how to get the identity of an inserted row? – stack kverflow [235] => how to get the identity of an inserted row? – stack lverflow [236] => how to get the identity of an inserted row? – stack pverflow [237] => how to get the identity of an inserted row? – stack 0verflow [238] => how to get the identity of an inserted row? – stack 9verflow [239] => how to get the identity of an inserted row? – stack ocerflow [240] => how to get the identity of an inserted row? – stack oberflow [241] => how to get the identity of an inserted row? – stack ogerflow [242] => how to get the identity of an inserted row? – stack oferflow [243] => how to get the identity of an inserted row? – stack ovwrflow [244] => how to get the identity of an inserted row? – stack ovsrflow [245] => how to get the identity of an inserted row? – stack ovdrflow [246] => how to get the identity of an inserted row? – stack ovrrflow [247] => how to get the identity of an inserted row? – stack ov4rflow [248] => how to get the identity of an inserted row? – stack ov3rflow [249] => how to get the identity of an inserted row? – stack oveeflow [250] => how to get the identity of an inserted row? – stack ovedflow [251] => how to get the identity of an inserted row? – stack ovefflow [252] => how to get the identity of an inserted row? – stack ovetflow [253] => how to get the identity of an inserted row? – stack ove5flow [254] => how to get the identity of an inserted row? – stack ove4flow [255] => how to get the identity of an inserted row? – stack overdlow [256] => how to get the identity of an inserted row? – stack overclow [257] => how to get the identity of an inserted row? – stack overvlow [258] => how to get the identity of an inserted row? – stack overglow [259] => how to get the identity of an inserted row? – stack overtlow [260] => how to get the identity of an inserted row? – stack overrlow [261] => how to get the identity of an inserted row? – stack overfkow [262] => how to get the identity of an inserted row? – stack overfpow [263] => how to get the identity of an inserted row? – stack overfoow [264] => how to get the identity of an inserted row? – stack overfliw [265] => how to get the identity of an inserted row? – stack overflkw [266] => how to get the identity of an inserted row? – stack overfllw [267] => how to get the identity of an inserted row? – stack overflpw [268] => how to get the identity of an inserted row? – stack overfl0w [269] => how to get the identity of an inserted row? – stack overfl9w [270] => how to get the identity of an inserted row? – stack overfloq [271] => how to get the identity of an inserted row? – stack overfloa [272] => how to get the identity of an inserted row? – stack overflos [273] => how to get the identity of an inserted row? – stack overfloe [274] => how to get the identity of an inserted row? – stack overflo3 [275] => how to get the identity of an inserted row? – stack overflo2 ) </h1> </body>