我试过它在SQL服务器中显示错误 [英] I tried it shows error in SQL server

问题描述

我有以下记录的表评论



原因

1148339 - GI NAGALOURGO

2108345 - VE DIWALOURGO



从上表我想要的输出如下



原因ID名称



1148339 - GI NAGALOURGO 1148339 GI NAGALOURGO

2108345 - VE DIWALOURGO 2108345 VE DIWALOURGO



对于我写的查询如下



选择原因，左（原因，CHARINDEX（' - '，原因）-1），

STUFF（原因，1，CHARINDEX（' - '，原因），''）

来自评论



当我运行上述查询时显示错误如下



传递给LEFT或SUBSTRING函数的长度参数无效。



如何解决以上错误。我上面的查询中有什么错误。



我尝试过：

I have table comments with records as follows

Reason
1148339 - GI NAGALOURGO
2108345 - VE DIWALOURGO

From the above table i want output as follows

Reason ID Name

1148339 - GI NAGALOURGO 1148339 GI NAGALOURGO
2108345 - VE DIWALOURGO 2108345 VE DIWALOURGO

for that i written query as follows

select Reason, Left(Reason, CHARINDEX('-', Reason)-1) ,
STUFF( Reason, 1, CHARINDEX('-', Reason), '')
from comments

when i run the above query shows error as follows

Invalid length parameter passed to the LEFT or SUBSTRING function.

how to solve the above error. what is the mistake in my above query.

What I have tried:

  I have table comments with records as follows

     Reason

   1148339 - GI NAGALOURGO
   2108345 - VE DIWALOURGO



 From the above table i want output as follows


   Reason                        ID          Name

   1148339 - GI NAGALOURGO    1148339       GI NAGALOURGO
   2108345 - VE DIWALOURGO    2108345       VE DIWALOURGO


for that i written  query as follows

  select Reason, Left(Reason, CHARINDEX('-', Reason)-1) ,
  STUFF( Reason, 1, CHARINDEX('-', Reason), '')
  from comments


 when i run the above query shows error as follows

Invalid length parameter passed to the LEFT or SUBSTRING function.


  how to solve the above error. what is the mistake in my above query.

推荐答案

尝试调试代码以查看从子字符串函数返回的值。

Try debugging your code to see what values are being returned from your substring functions.

这篇关于我试过它在SQL服务器中显示错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！