Hi,

Try something like this. What I have done is that I have taken table name, field name, data type of field name and actual value of field name...

Try this

DECLARE @Condition nvarchar(100)

DECLARE @SQLString NVARCHAR(500)

set @Condition = ' <whatever condition> '

SET @SQLString = 'SELECT * FROM customer WHERE ' + @Condition

EXECUTE sp_executesql @SQLString

-- Now execute the second condition

set @Condition...

quote:

---

How do i update the field having the ntext datatype by using the cursor in a stored procedure.

Check the READTEXT, UPDATETEXT and...

Hi,

I have already set SET NOCOUNT ON. But what I am gettting is the result of SELECT statements. I have to fetch some records for intermediate computations and...

Hi All,

Thanks to all of you for the information. This helped me a lot.

Ashish

Hi,

I am new to this and I dont have any idea how to go about this. Can you give me the steps to do this OR any...

Hi,

Found the solution.

Instead of using the table schema directly in the OPENXML, explicitly give the schema definition. So the statement will read something like...