Top "Calculated-columns" questions

A calculated column is calculated from an expression that can use other columns in the same table

Convert computed column to regular column

I have a persisted computed column in a large table in in SQL Server 2005. I want to convert it to …

sql-server calculated-columns
define a computed column reference another table

I have two database tables, Team (ID, NAME, CITY, BOSS, TOTALPLAYER) and Player (ID, NAME, TEAMID, AGE), the relationship between …

sql-server-2008-r2 calculated-columns
How to create mean and s.d. columns in data.table

The following code/outcome baffles me as to why data.table returns NA for the mean functions and not the …

r data.table mean calculated-columns
Persisted computed column with subquery

I have something like this create function Answers_Index(@id int, @questionID int) returns int as begin return (select count([…

sql-server calculated-columns
Computed bit column that returns whether another column is null

I try to have this computed column: CREATE TABLE dbo.Item ( ItemId int NOT NULL IDENTITY (1, 1), SpecialItemId int NULL, --I …

sql-server-2005 null calculated-columns isnull
Adding virtual columns to current table in Doctrine?

I'm using Doctrine 1.2 with Symfony 1.4. Let's say I have a User model, which has one Profile. These are defined as: …

join symfony1 doctrine calculated-columns doctrine-1.2
Sharepoint, Calculated column, IF function and date

I am trying to add a calculated column. I have a date column containing the date a meeting is scheduled. …

sharepoint calculated-columns sharepoint-2003
Alter SQL Function Referenced by Computed Column

If you set up a table's column to be a computed column whose Formula calls a Function, it becomes a …

sql-server-2005 calculated-columns sql-function non-deterministic
How to change a normal column to "computed" column

I have a table in MSSQL server 2008. I would like to change one of the column in that table to …

sql-server calculated-columns
add column to data frame, testing categorical variable in other column

I have referred: How to add a factor column to dataframe based on a conditional statement from another column?, How …

r for-loop dataframe conditional-statements calculated-columns