Executing Dynamic SQL with Exec. Problem with dot (.) In string variable in dynamic SQL

hzjqonly

set @ vSQL = @ vSQL + 'delete from' + @ FSrvName + 't_Item where FNumber =' '' + @ FDeNumber + '' 'and FItemClassID = 2001'

Execute (@vSQL)

The value of the string variable (@FDeNumber) in the above dynamic SQL (@vSQL) is: '03 .001 ', and an error is reported after execution.
But when there is no dot in the middle of the string variable value, such as: '03001', it can be executed normally.
Seeking solutions, 100,000 rush !!!

unkmass

What type is FNumber?

pupupu01

Dynamic SQL has nothing to do with ".", Look for other errors.

set @ vSQL = @ vSQL + 'delete from' + @ FSrvName + 't_Item where FNumber =' '' + @ FDeNumber + '' 'and FItemClassID = 2001'
print @vSQL-use the print result to execute it.

--Execute (@vSQL)


unkmassBrother is still online. It's not easy, I'm going to rest.

fanfan1980

Should be an error during data type conversion

fanfan1980

declare @str varchar (10)
set @ str = '03 .001 '
select cast (@str as int)
-Error

declare @str varchar (10)
set @ str = '03001'
select cast (@str as int)
--OK

821105

-----------------------------------
Select @ vSQL = ''-here the variable is assigned (it can be empty or other values)
-----------------------------------

set @ vSQL = @ vSQL + 'delete from' + @ FSrvName + 't_Item where FNumber =' '' + @ FDeNumber + '' 'and FItemClassID = 2001'

Execute (@vSQL)

litblue

declare @str varchar (10)
set @ str = '03 .001 '
select convert (decimal (5,3), @ str)

prajna

What's wrong?

我是杀人狂

It should be for the sake of data type conversion ..