Home > .Net | SQL > Specifying values for In clause in SP from C#

Specifying values for In clause in SP from C#

select  * from pk where charindex(‘,’+cast(pkid as varchar(50))+’ ‘,’,12 ,13 ‘,1) > 0

But I think i would be slow if you have large data

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">

Trackbacks:0

Listed below are links to weblogs that reference
Specifying values for In clause in SP from C# from extremeweblog.com
TOP