如何在sql server 2008中连接两个没有公共列的表 [英] How to join two tables having no common columns in sql server 2008

问题描述

您好，任何人都可以说如何在两个表中没有公共字段的情况下加入两个表。

我在下面尝试了链接，但是有一个错误，最初它成功执行但后来才开始显示太多行：

消息217，级别16，状态1，过程Pro_Combine_Dept_Location，行25

超出最大存储过程，函数，触发器或视图嵌套级别（限制32）

和链接是



1. 点击这里 [ ^ ]



两个链接都会成功启动，但之后会显示已编译错误。



我需要输出，请帮助我。

解决方案

请检查以下li nk为了更好地理解并且必须分析你的嵌套功能。



错误：超出最大存储过程，函数，触发器或视图嵌套级别（限制32）？ [< a href =http://www.codeproject.com/Questions/364657/Maximum-stored-procedure-function-trigger-or-viewtarget =_ blanktitle =New Window> ^ ]

Hello, can anyone say how to join two tables without having no common fields in the both tables.
I tried below given links but there is a error, initially it executes successfully but later on it shows too many lines :
Msg 217, Level 16, State 1, Procedure Pro_Combine_Dept_Location, Line 25
Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)
and the links are

1. Click here [^]

both links executes success starting but after that it shows compiled with errors.

I need the output like that please help me.

解决方案

Please check the below link for better understanding and have to analyse your function for nesting.

error:Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)?[^]

这篇关于如何在sql server 2008中连接两个没有公共列的表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！