@ vijay.singh 14112 :

Thanks a lot for the reply and the help will check it out.

Thankyou for your reply . i created a table before .. see for example i created ...

CREATE TABLE [dbo].[Allemailids] (

[AutoID] int identity(1,1),

[Email ID's] nvarchar(255)

)

and when now using import and export...

@hanshi:

Thank you.It worked correctly but if i want to use with multiple items then there is a problem in this.i want both.

For example:

search_row 'sqldeveloper','hyd'

so here i want all...

@ dwain.c.

Once again thank you but what i wanted is somewhat different.for example in the execution samples which you provided i want as below:

Instead of this : exec search_row null,...

Thanks for your reply.can you please help me in using the dynamic query ?

Ya i created and saw the result.

Thanks all

No i am planning to take the exam.So preparing.If you know the answer can you clear my doubt?

Thank you

@thank you pettis