Well,

To be precise, I would like to know is there any method in SQL Server like

autonomous transaction pragma in Oracle ?

Cheers

Sorry for all the confusion.

I have a program that work exaclty as of an identiy property. But it doesn't support concurrecy as it does like IDENTITY column property.

We...

Has to be an integer. I don't want to use a 16 bit Unique identifier.

try this one ...

DECLARE @ptrval binary(16)

SELECT @ptrval = TEXTPTR(CustText)

   FROM customer WHERE CustId = 10

UPDATETEXT Customer.CustText @ptrval  null null  'ABCD'

GO

for more info have a look at UPDATETEXT...

I think there is no other way since SQL server doesn't allow to concatinate nText , image etc datatypes. Don't know if there is any other work around if it exceeds...

try this

UPDATE Customer SET CustText = cast(CustText as varchar(8000)) + 'ABCD'

WHERE CustId = 10

cheers

Rajesh

use

set statistics io on and

set statistics time on

Find out how much time it takes to compile and parse each quires (old quires as well as new quires)...

Thank you very much for the responses. Well, I have realised that when running from QA execution plans are not getting cached effectivly as it does when runnning from application.

I have...

Well, the question I have posted was based on a test that I had done not less than 10 times. In the sense considering the data cache and execution plans of...

Hi Remi,

I really appreciate the courtousy you have shown me to reply.

Well, to my knowwledge the dataset returns is exactly the same. If we are running the SQl...