Results 1 to 2 of 2

Thread: Execution Time In SQL

  1. 08-23-2007 #1
    Siva_Tech
    Siva_Tech is offline
    Junior Member
    Join Date
    Jul 2007
    Answers
    6

    Execution Time In SQL

    Can anyone tell of how to check the time of execution of a stored procedure in SQL 2000 and do any one have any idea of the steps for query optimization? Thanks in advance.

    --Siva--

    Reply With Quote Reply With Quote
  2. 11-30-2007 #2
    kumaresforu
    kumaresforu is offline
    Junior Member
    Join Date
    Nov 2007
    Answers
    5

    Re: Execution Time In SQL

    U can use

    Wait for delay'00:00:02'
    selct * from table

    (or)

    Wait for Time'10:00'
    selct * from table

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
GeekInterview
Interact