Viewing 2 posts - 1 through 2 (of 2 total)
b) and f) are correct answer, as records from child is removed before parent. It is not mentioned any where that logging is required, and in production environment truncate...
March 10, 2015 at 5:47 am
#1782852
CREATE TABLE TEST
(
nIDENTITY numeric(38,0) identity(10000000000000000000000000000000000000,1),
nNo int)
INSERT TEST
SELECT 1
UNION ALL
SELECT 2
SELECT LEN(nIDENTITY),nNo
FROM TEST
January 19, 2015 at 10:17 pm
#1771290