Top "Calculated-columns" questions

Cannot persist computed column - not deterministic

I have this function for a computed column : CREATE FUNCTION [dbo].[GetAllocatedStartTime](@Year INT, @Week INT) RETURNS DATETIME WITH schemabinding …

sql-server database sql-server-2008-r2 calculated-columns

Get Year of CreatedBy date in a calculated column

I am trying to create a calculated column in SharePoint 2007. I want it to return the year of the CreatedBy …

sharepoint-2007 sharepoint-2013 calculated-columns

Best Practices for Computed Column in SQL Server

I'm working with a user table and want to put a "end of probational period date". Basically, each new user …

sql-server sql-server-2012 calculated-columns

SharePoint: Calculated Column Values Disappear When Editing List Item. Any ideas?

I have a calculated column in a custom SharePoint 2007 list, with the following formula: =CONCATENATE("IR-",[ID],"-",LEFT(UPPER([…

sharepoint calculated-columns

Can I create computed columns in SQLite?

What would be the syntax (if it's possible), for example, to create a table called Car_Model that has a …

sqlite calculated-columns

how to create calculated field in mysql?

i have a table like below: create table info (username varchar(30),otherinfo varchar(100)); now i want to alter this table …

sql mysql calculated-columns

SQL Server - INSERT failed because of 'ARITHABORT'

I use NHibernate and SQL Server 2005 and I have an index on a computed column in one of my tables. …

sql-server sql-server-2005 calculated-columns database-indexes

Sql Server deterministic user-defined function

I have the following user-defined function: create function [dbo].[FullNameLastFirst] ( @IsPerson bit, @LastName nvarchar(100), @FirstName nvarchar(100) ) returns nvarchar(201) as begin …

sql sql-server-2008 function calculated-columns non-deterministic

SQLAlchemy calculated column

(New SQLAlchemy user alert) I have three tables: a person, the persons hourly rate starting at a specific date, and …

python sqlalchemy calculated-columns

SQL Server - index on a computed column?

I'm joining to a table dozens of different times, and every time, I join (or filter) based on the results …

sql-server sql-server-2008 indexing calculated-columns