How to create a computed column based on the Title nvarchar(max) column of another table?
I want to make Title in table 1 a computed column from table2 based on docId = DocId. I keep trying to add it as computed column in SSMS and it won't let me.
Table1
AssetId Title DocId
========================
Table2
DocId Title
=========================
5 Disaster
10 Recovery
15 Pending
The definition of computed columns explicitly states that the columns must be in the same table (here).
What you probably want is a view.
create view vw_table1 as
select t.AssetId, d.Title, t.docid
from table1 t left outer join
table2 d
on t.docid = d.docid
You can't create computed column using another table column. But you can define Table 1 as AssetId, DocId and create view as you desired.
CREATE VIEW YouVIEW
AS
SELECT T1.AssetId, T1.DocId, T2.Title
FROM Table1 T1
JOIN Table2 T2
ON T1.DocId = T2.DocId
This is parametrized inline function
CREATE FUNCTION dbo.GetValue (@DocId INT)
RETURNS TABLE
AS
RETURN
(SELECT T1.AssetId, T1.DocId, T2.Title
FROM Table1 T1
JOIN Table2 T2
ON T1.DocId = T2.DocId
WHERE T1.DocID = @DocId
)
GO
JOIN?