Diana:
*****
PRINT 'Duration with table variable: ' + CAST(DATEDIFF(ms, @StartTime, getdate()) as varchar(10)) + ' ms'
*****
PRINT 'Duration with temp table: ' + CAST(DATEDIFF(ms, @StartTime, getdate()) as varchar(10)) + ' ms'
Din cate stiu performanta nu are nici o legatura cu timpul de executie.
Timpul de executie depinde de pc pe care ruleaza.
Performanta depinde de sec CPU si Reads pe care le vezi intr-un SQL profiler :D
Nu ?
Multumesc,