Please give me ideas

zuoshou

I wrote it like this:
string [] ary = this.ViewState ["卡号"] .ToString (). Split (',');
What should Sql write?

looser_01

CREATE PROCEDURE Test
    @idString NVARCHAR (1000)
AS
    DECLARE @sql NVARCHAR (2000)
    --If the card number is a string
    set @idString = '' '' + replace (@idString, ',', '' ',' '') + '' ''

    SET @sql = 'select * from Users where card number in (' + @idString + ')'
    exec @sql