procedure take array parameter in sql server?

This situation is usually handled by passing a delimited string, "1,2,3,4" then parsing it into inividual components in the stored proc with string handling methods. There are good number of examples for this.

Another method, if you can use it, is to created a .net managed stored proc since .net of course has better string manipulation capabilities than tsql

Google is your friend: Be nice and visit him often. He can answer questions a lot more quickly than posting them here...
For example, I fed your question subject into Google and it suggested this article on this site:

Array Parameter Handling in a Stored Procedure[^]

Now, why couldn't you do that?