没脾气2x · 2009-04-13 02:30:13 · 阅读: 464 …… UPDATE forum_msgs SET BlockId = -1 SELECT MessageId FROM forum_msgs WHERE BlockId IN ( SELECT BlockId FROM forum_msgs WHERE messageFromUserid = @THEUSERID and parentmessageid IS NULL and BlockId != -1 )