I have a stored procedure. I want to check how much time it takes to execute. Please note that I don't have access to profiler. I am using SQL server 2005
I tried using the following batch query
SELECT CONVERT( VARCHAR(24), GETDATE(), 121)
EXEC cif_query_trans_by_card_Final2 '0060F423F28A6095AD070CEFFD7E81D245D7D0CD7B', '11223345'
SELECT CONVERT( VARCHAR(24), GETDATE(), 121)
But I am getting same value in both timestamp as 2014-12-30 18:09:52.653
Any help will be greatly appreciated.
Thanks in advance.
Aucun commentaire:
Enregistrer un commentaire