部门周计划表 Hr_DepartPlanWeek ：
DepartMent部门名称，DepartMentID部门ID。
部门表 g_group：
gname部门名称，gid部门id
根据DepartMentID 修改表 g_group的DepartMent字段
update Hr_DepartPlanWeek set DepartMent=t.gname from (select gname,gid from g_group left join Hr_DepartPlanWeek on g_group.GId=Hr_DepartPlanWeek.DepartMentID )t where t.GId=Hr_DepartPlanWeek.DepartMentID
T_Content 博客表
T_ContentType 博客类别表
同一个博客类别包含多少篇博客
string sql = "select (select count(*) from T_Content where FTypeId=T.FID) as num from T_ContentType AS T"