This internal SATA cable has locking 7 pin SATA on both ends. It is typically used to provide maximum retenion when connecting a SATA hard drive to a motherboard.
This external SATA cable consists of a external 'L' SATA 7 pin on one end and a external 'I' eSATA 7 pin on the other end. It is typically used on eSATA devices.
This SATA power cable consists of a 15 pin SATA on one end and a 4 pin LP4 internal power on the other end. It is used to power a SATA hard drive from a conventional LP4 connection.