ฉันพูดว่า 'ตารางสาระสำคัญ' กี่ครั้งแล้ว? ไม่จำเป็นต้องใช้ตารางทั้งหมด
how many times have I said 'pivot table'?.It is not neccessary to use all the tables.
 SuggestedEditVotes:  Id [ number]  SuggestedEditId [ number]  UserId [ number]  VoteTypeId [ number]  CreationDate [ time]  TargetUserId [ number]  TargetRepChange [ number] 
SELECT 'Pivot Table comments' AS pType, UserId AS "user_link", COUNT(Id) AS numMentions FROM Comments WHERE UserId IN ('##UserID##') AND Text LIKE '%pivot table%' COLLATE SQL_Latin1_General_CP1_CI_AS GROUP BY UserId UNION SELECT 'Pivot Table posts' AS pType, OwnerUserId AS "user_link", COUNT(Id) AS numMentions FROM Posts WHERE OwnerUserId IN ('##UserID##') AND Body LIKE '%pivot table%' COLLATE SQL_Latin1_General_CP1_CI_AS GROUP BY OwnerUserId