type difference

[cody]

create the param by concatenating the id's:

string param = id1+","+id2+","+id3;

 

[Viktor Popov]

Hi,

I am tryind to delete from a table using a Stored Procedure, but I don't
know how to do the following:

The DELETE STATEMENT must be:

DELETE FROM MESSAGES
WHERE MSSGID IN (@MSGIDS)

The problem is that @MSGIDS always is something like this:
1,3,5,7,11,12. It's VARCHAR parameter. The problem is that MSSGID is the
Primary key and it is INT. How could be solved this problem?

Thank you in advance!

Viktor

 

[Hugo Wetterberg]

Hi Viktor,
It looks like you need something like the Javascript Eval() function,
rather than getting the correct type.

You could pass the string as usual and then split it in SQL-Server and
store it in a temporary table. Take a look at this article:
http://www.winnetmag.com/SQLServer/Article/ArticleID/21071/21071.html

/Hugo