摘要： --select * from province left join city on city.fatherID=province.provinceId --group by province.provinceIddeclare @id int ,@temp nvarchar(20),@str nvarchar(2000)declare myCursor cursorfor select provinceId from provincecreate table #cc( id int, citys nvarchar(300))open myCursorfetch next from my... 阅读全文