Home Forums Article Discussions Article Discussions by Author Discuss content posted by Sunny Parallel Processing RE: Parallel Processing

  • October 12, 2009 at 3:12 am

    #1064622

    iermis (10/12/2009)

    As I am new to SQL i cannot understand why you are using the statement

    SELECT * INTO #LockHelp FROM Rainfall_Events WITH (TABLOCKX) WHERE 1=2. This statement does not fetch any rows?

    It must be something about the lock time, bit can you explain me why you are using "WHERE 1=2"?

    Thank you

    I think Sunny is using this "WHERE 1 = 2" for creating the #LockHelp table only, having no data.

    But not sure why, because he has not refer #LockHelp in the SP.