A Question on IsPersisted Property of Computed Columns

  • Hi all,

    I have a pretty basic question on computed columns. What difference does it make if the IsPersisted property is set to Yes or No? So far I couldnt see any difference between the two using a test table in my db, the column gets updated whether it is persisted or not.

    I'm using SQL Express 2005, the front end application is writen in asp.net. Would the IsPersisted have any effect?

    Thank you for any help and advice.

  • Hello Afendi,

    if your problem relates to SQL2005, it would be better to post it in SQL2005 section of the forums. You'd have much higher probability of getting a reply quickly there than here. Go to Forums Home and find the appropriate forum to post your question. Good luck!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply