The records of the picture is from a SQL trace record(it was saved by the trace file, generated in SQL Server 2008). and the records are sorted by its starttime.
as I'm not familiar with sp_prepare ?sp_execute and sp_unprepare , could you please tell me what are the uses of them ? and in which situation these 3 system procedures will be executed ?
and will they be executed together ? if yes, how about the sequence to be executed? (first to exeute sp_prepare, then to execute sp_execute, final to execute sp_unprepare )?