Hello, I got error when I'm tryi

[wuwang]

Hello,

I got error when I'm trying to put the character statement in SELECT statement (I just want to show the DELETE record statment) like below:

select 'DELETE table WHERE table_ID = ' + table_id
from table
where table_id in (1234, xxxxx,xxxxx)

How can I resolve this problem. Thank you for your help
in advance.

 

[Tim1]

Hiya,

Exactly what error are you getting? I have tried your code and it works fine on my system.

Tim

 

[wuwang]

Since datatype of table_id is int.
I need to use Convert function to transfer the id as varchar and it works.

Thank you again.

 

[Cagliostro]

you can do
declare @xxx varchar(500)
set @xxx = 'DELETE table WHERE table_ID = '
select @xxx + table_id ..... John Fill

ivfmd@mail.md