# * Displayed when converting SqlServerint type to varchar type

When the SQL Server int type is converted to the varchar type, a bug is called today. The error message is that a syntax error exists near the statement *. After reading the Stored Procedure for half a day, I didn't respond to it *. print the following statement and find the whereMor_where statement. Convert the int row Id to the varchar type, because

The SQL Server int type to varchar type shows a bug called today. The error message is that a syntax error exists near the execution statement *. After reading the Stored Procedure for half a day, I didn't respond *. print the statement and find that the where Mor_Id = * carefully read the set @ sqlupdate + = 'where' sentence, convert the int row Id to the varchar type, because

Int type to varchar type *

Today, I called a bug and reported that there was a syntax error near the execution statement *. After reading the Stored Procedure for half a day, I did not respond to the website space *. print the statement and find where Mor_Id = *

Take a closer look at the phrase set @ sqlupdate + = 'where' and convert the int row Id to the varchar type. Because the id is too large, it becomes *

Posted on

, Website space, Hong Kong server