Based on the provided search results, there are several completed historical fiction novels set in the Northern Song Dynasty (960-1127) that are worth recommending. These novels cover a variety of genres, including military warlords, farming, professions, and alternate history. Here are some recommendations:
1. "紹宋" (Shao Song) by 榴彈怕水: This novel depicts the events following the fall of the Northern Song Dynasty and the struggles of the protagonist to resist the Jin Dynasty. However, the main character suffers from amnesia after falling into the Nine Dragon Well, which complicates his efforts to resist the Jin Dynasty.
2. "大宋帝國(guó)征服史" (The Conquest History of the Great Song Empire) by cuslaa.QD: This novel follows a protagonist who travels back in time to the Northern Song Dynasty and becomes a pirate's son. He rises through the ranks of the pirates and eventually becomes their leader.
3. "北宋大丈夫" (The Great Man of the Northern Song) by 迪巴拉爵士: This novel tells the story of a protagonist who travels back in time to the period of Emperor Renzong of the Song Dynasty. After his father's death, he faces persecution from the civil officials and seeks refuge in the capital city. The novel focuses on his journey to become a great man and bring strength to the Song Dynasty.
4. "北宋小廚師" (The Little Chef of the Northern Song) by 南希北慶: This novel follows the story of a modern-day chef who miraculously travels back in time to the late Northern Song Dynasty. As a highly skilled chef, he uses his culinary talents to navigate the challenges of the era.
Please note that these recommendations are based solely on the provided search results and may not encompass all completed novels set in the Northern Song Dynasty.