如何解决此错误“您的Sql语句的某些部分嵌套太深。重写查询或将其分解为更小的查询。 [英] How Do I Solve This Error "Some Part Of Your Sql Statement Is Nested Too Deeply. Rewrite The Query Or Break It Up Into Smaller Queries."

问题描述

"Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries."

i have 120 query statements in my stored procedure.
I am getting this error when i add another one,it not allow me to write more than 120 query's .i googled it,but it's said to split the query.is there any other way to solve this issue.

推荐答案

在存储过程中写下这么多查询并不是一个好习惯，我相信。



如果错误消息表明您无法进一步添加查询，则无法添加。

Writing these many queries inside Stored Procedure is not a good practice, I believe.

If the error message suggests that you can't add queries further, then you will not able to add.

这篇关于如何解决此错误“您的Sql语句的某些部分嵌套太深。重写查询或将其分解为更小的查询。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！