It would be easier to give a complete answer with the Profiler events and filter. However, on a guess, the process id changed? They're not always the same. If...

Thanks Grant Fritchey!  The connection process ID wasn't changed, when I login system (C/S system), I check its process ID under windows task manager, and I didn't log out this...

thank you for your kind help!

Because your using string literals to represent a datetime format.

CONVERT(VARCHAR(6), '2020-09-23 00:00:00.000', 112)

The above is taking a string and converting it into a 6 character string.

Datetimes...

SELECT TableVariableTypeName = tt.name
     , ColumnName = c.name
     , ColumnNumber = c.column_id
    , [DataType] ...

thanks !

but  there are some parameters of actual execution plan such as cached plan size/Memory grant/Estimated subtree cost ...,

if we compare which sql statemest is better as the said sql...

hmm, I saw some books or article says the execution plan is inaccurate , if like this how we can compare which sql statement is better ?

I used actual execution...

thank you so much, Jo pattyn!

Sorry for my bothering !

How to calculate the RAM used while running a query, for example, I run the following code, how can I know the RAM used by this...

thanks eveyone in advance!

anyone can help me with my said questions, thanks!

Yes, thank you Mike and Jeff!

Dear Jeff,

Thank you for kind help!

I quite agree with you!

my said procedure, I just want to verify  how the transaction(rollback) works on the said scripts, actually, when the 1st block...

Dear All,

for the said question1 to question4, I encoded some source code to test and I already understand, for the case 1 to case 4, there is only one spid ...

Thank you Mike and Chris. but I have one question about sql server process (SPID) .

there are two stored procedures.one is SP1 the other is sp2. sp1 and sp2 has...

thank you Grant Fritchey!

I just want to know if there is another way to do it. I know extended event can do it. thanks!