在存储过程中收到错误 [英] getting error in stored procedure

问题描述

我收到错误

's'附近的语法不正确。



我有疑问：

插入K2_NQISQI值（'6月-14'，'GSM NQI'，'AP'，97.83,96.71，'向下'，'RF KPI''降级主要是因为高阻塞单元（增加来自0.13至0.23）（推出问题） 以及由于非DG站点中断，于15日2016年2月23日24日26日和29日因双纤维削减导致400个站点中断和27个站点中断，大约220个站点中断。'）

我应该把代替'



提前致谢

Harshal

解决方案

查看这个。

  INSERT   INTO  K2_NQISQI  VALUES （'  June-14'， '  GSM NQI'，'  AP'， 97 。 83 ， 96 。 71 ，'  down'，'  RF KPI''''降级主要是因为高阻塞单元（从0.13增加到0.23） （推出问题）和由于非DG站点中断于15日16日至23日24日26日和29日因双光纤切断导致400个站点中断和大约220个站点在27和29次停机。）

希望这会对你有所帮助。

我不确定但是

'部分RF KPI的' - 接缝对我来说很奇怪

不应该是'RF KPI'的'



是'RF KPI' '降级......一共？

试试这样：

  INSERT   INTO  K2_NQISQI  VALUES （'  June- 14'，'  GSM NQI'， '  AP'， 97 。 83 ， 96 。 71 ，'  down'，'  RF KPI的降级主要是
因为高阻塞
单元格（从0.13增加到0.23）（首次展示问题）和因非非DG网站中断于15日16日23日
 24th26th 27th和29 
导致400个站点中断和由于双纤维切割，27日和29日大约有220个站点中断。'）

I am getting an error
Incorrect syntax near 's'.

I have a query :

INSERT INTO K2_NQISQI VALUES('June-14','GSM NQI','AP',97.83,96.71,'down','RF KPI's' Degraded mainly because of high blocking cells(Increased from 0.13 to 0.23) (Rollout issues)  and because of Non DG site outages on 15th16th20th23rd 24th26th 27th and 29th resulting in 400 sites outage and about 220 sites outages on 27th and 29th due to Dual Fiber cuts.')

Should i need to put "" instead of '

Thanks in advance
Harshal

解决方案

Hi,

check this one.

INSERT INTO K2_NQISQI VALUES('June-14','GSM NQI','AP',97.83,96.71,'down','RF KPI''s'' Degraded mainly because of high blocking cells(Increased from 0.13 to 0.23) (Rollout issues)  and because of Non DG site outages on 15th16th20th23rd 24th26th 27th and 29th resulting in 400 sites outage and about 220 sites outages on 27th and 29th due to Dual Fiber cuts.')

Hope this will help you.

I am not that sure but the section
'RF KPI's' - seams quite strange to me
should n't it be 'RF KPI''s'

is 'RF KPI's' Degraded.... altogether ?

Try like this :

INSERT INTO K2_NQISQI VALUES('June-14','GSM NQI','AP',97.83,96.71,'down','RF KPI"s Degraded mainly 
because of high blocking 
cells(Increased from 0.13 to 0.23) (Rollout issues)  and because of Non DG site outages on 15th16th20th23rd 
24th26th 27th and 29th 
resulting in 400 sites outage and about 220 sites outages on 27th and 29th due to Dual Fiber cuts.')

这篇关于在存储过程中收到错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！