string sql="SELECT Moderator FROM T_BBS_Board WHERE ID=(SELECT BoardID FROM T_BBS_Topic WHERE ID=(SELECT TopicID FROM T_BBS_Post WHERE ID=@postID))"
像上面的语句.比起直接做个视图.哪个效率更高?
...全文
36210打赏收藏
视图和嵌套查询哪个效率更高.
string sql="SELECT Moderator FROM T_BBS_Board WHERE ID=(SELECT BoardID FROM T_BBS_Topic WHERE ID=(SELECT TopicID FROM T_BBS_Post WHERE ID=@postID))" 像上面的语句.比起直接做个视图.哪个效率更高?