James Bond (Sean Connery) used to shoot a Walther PPK. Then when Bond was played by Pierce Brosnan, it was a Walther P99, both in 9mm. Later, Daniel Craig as Bond carried a SIG P220 in 45ACP.
Ian Fleming in the Bond Novels gave him a Baretta 418 in 25 auto. <---- pea-shooter!
Oh,......... wait!
You meant pool cues!
Sorry, that's a secret, (Black OPs could not even get that outta me!)