本文介绍了无法移除Squiggly线的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我创建了sp并在现有表中添加了一些列并更新了新列

I created sp's and added some column in existing table and updating the new column

但是  SQuiggly行来了,说列名无效但列名存在。

but  SQuiggly line coming and saying invalid column name but the column name is existing.

例如

update t2 set t2.column1 = t1.column1 
table1作为t1,table2作为t2其中t2 .id = 1

请帮助

Kindly help

推荐答案

更新t2 

set t2.column1 = t1 .column1 

从table1为t1,table2为t2 

其中t2.id = 1   << =您需要将t1与t2连接起来,例如t1.id = t2.id等,但不确定是否会出现波浪线,因为它应该按原样运行,虽然错了

update t2 
set t2.column1 = t1.column1 
From table1 as t1, table2 as t2 
where t2.id=1   <<= You need to join t1 with t2, such as t1.id = t2.id etc but not sure about squiggly line though because it should work as is, although wrong


这篇关于无法移除Squiggly线的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

10-30 02:21