But it all depends on the host machine's BIOS and the SATA card you choose. Next up is that XP (a common OS today) doesn't come equipped to install and boot from SATA. There can be extra steps to install this aging OS and some will require the even older and often missing floppy drive.
But if you choose a card that notes as bootable and you follow the many extra steps to install this OS then you might be successful. I know that better than 1 in 2 installers will not get this to work.
Bob
Can a hard drive that is connected through a PCI adapter be the primary hard drive with the operating system on it?

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic