Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Persisting Calculated Columns in SQL2005

35 views
Skip to first unread message

randy.buchholz

unread,
Aug 30, 2007, 10:10:59 AM8/30/07
to
Anyone know how/if PD supports persisted calculated columns in SQL2005? If
I create a table (like below) and reverse it, it doesn't reverse the
'PERSISTED' decoration.

CREATE TABLE [dbo].[Table_1](

[c1] [nchar](10),

[c2] [nchar](10),

[c3] AS ([C1]+[C2]) PERSISTED

)


Matt Creason

unread,
Aug 30, 2007, 11:59:11 AM8/30/07
to
Doesn't look like it. You can either modify the xdb or better yet call
TechSupport and have them since this is a standard, yet little known,
feature of SQLServer 2005.

-Matt C.
"randy.buchholz" <randy.b...@dads.state.tx.us> wrote in message
news:46d6cff3$1@forums-1-dub...

0 new messages