Computed columns

Question

Computed columns

GuruGPrasad

SSCommitted

Points: 1768
More actions
February 10, 2012 at 1:09 am

#268075

Hi All,
Can we create a computed columns that relates from another tables?
Regards,
Guru

Viewing 6 posts - 1 through 5 (of 5 total)

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

Dave Brooking Ten Centuries Points: 1373 More actions · Answer 1

There was a recent QOTD about computed columns. The question can be found at http://www.sqlservercentral.com/questions/features/87846/ and the discussion here http://www.sqlservercentral.com/Forums/Topic1244022-1222-1.aspx

Dave

Jayanth_Kurup SSC-Insane Points: 22967 More actions · Answer 2

Quick answer no , at least not in the traditional sense of what a computed column is , however the column can use a UDF which in turn references a column from another table.

Jayanth Kurup[/url]

GuruGPrasad SSCommitted Points: 1768 More actions · Answer 3

GuruGPrasad

SSCommitted

Points: 1768

February 10, 2012 at 1:40 am

#1445392

Thank u Dave and Jayanth

Regard

Guru

HowardW One Orange Chip Points: 29109 More actions · Answer 4

Although you can work around it using a UDF that references another table, you can't persist them as they're non-deterministic. If you need to index/persist the result, it might be worth looking into indexed views instead.

spaghettidba SSC Guru Points: 105732 More actions · Answer 5

A scalar UDF in this context would be a performance nightmare. I would avoid it like the plague.

Why not use a view instead?

-- Gianluca Sartori