一次意外的X锁不阻塞问题

    最近有一个朋友问我一个关于给查询操作强制上X锁却不阻塞的问题。该查询写在一个存储过程中，代码如代码1所示：

   1: create PROC [dbo].[GetCityOrders]

   2:     @city NVARCHAR(10) ,

   3:     @num INT

   4: AS

   5:     SET NOCOUNT ON

   6:  

   7:     BEGIN TRY

   8:  

   9:         BEGIN TRAN

  10:  

  11:         SELECT TOP ( @num )

  12:                 id ,

  13:                 number ,

  14:                 price ,

  15:                 mid ,

  16:                 @city city

  17:         INTO    #cityorders

  18:         FROM    cmcc WITH ( XLOCK )