没脾气2x · 2009-04-13 10:30:13 · 阅读: 477 …… 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 )