Tag: computed-column

Found 42 results for 'computed-column'.

1) postgresql - Postgres 9.6.5 - Can I use a query to calculate a value from two columns and insert the calculated value in a new column in the same table?
2) mysql - MySQL - How do I Calculate an Average Value Over a Period of Time When Only Value Changes are Recorded
3) sql-server - SQL Server FullText search on non-persisted columns
4) sql-server - Index on VARCHAR(MAX) column
5) postgresql - How can I add a numeric version_id column to an existing table?
6) postgresql - How to add a generated column with an expression subtracting days?
7) sql-server - Creating Non-Clustered Index on Non-Persisted Computed Column SQL Server
8) sql-server - Index on Persisted Computed column needs key lookup to get columns in the computed expression
9) sql-server - Computed Column Index Not Used
10) sql-server - Use a scalar hashing function in a computed column - non-deterministic?
11) sql-server - Why is the result of a totally deterministic and all-encompassing "case" in select query in view nullable?
12) sql-server - Creating a Persisted Computed Column with a function
13) sql-server - Why is a NOT NULL computed column considered nullable in a view?
14) sql-server - HashBytes Computed Column: Exclude Column
15) sql-server - Type conversion in expression may affect “CardinalityEstimate” - on a computed column?
16) postgresql - Using NEW on tables with generated columns
17) trigger - SQLite: Using count in triggers to update another column
18) sql-server - Computed column cannot be persisted because the column is non-deterministic
19) sql-server - Is any caching mechamism used for non-persisted computed columns?
20) sql-server - Sql Max value from multiple columns in Computed Column
21) mysql - Rank rows using weighted average with multiple sub queries
22) sql-server - Can I create a computed column that requires input to select?
23) sql-server - Add computed column with "IN" syntax
24) oracle - Create a function column that is the result of OR between 3 columns
25) sql-server - AutoIncrement non-primary key or Make unique composite key?
26) sql-server - Table with persisted computed CLR originated data marked with has_unchecked_assembly_data = 1, but DBCC CHECKTABLE does not unset this same flag
27) mysql - Is there a way to avoid having chained/nested “replace()” items when using an ISO 8601 timezone offset value in a generated column?
28) sql-server - Changing primary key from IDENTITY to being persisted Computed column using COALESCE
29) postgresql - Alternative to Self Join
30) sql-server - Unable to create a Filtered Index on a Computed Column
31) sql-server - Is it legal for SQL Server to fill PERSISTED columns with data that does not match the definition?
32) postgresql - PostgreSQL: Generated Columns
33) sql-server-2012 - computed column as foreign key allow null
34) sql-server - When are computed columns computed?
35) mysql - Insert into table with column same values as auto increment column ( computed column )
36) mysql-5.7 - Adding computed column extremely slow
37) postgresql - Create an unique integer id column for an existing string column
38) db2 - How to add generated column to db2 table?
39) sql-server - SQL Server Scalar UDF Parallelism Mystery!
40) oracle - Intended use case for virtual columns with function-based index?
41) sql-server - How to create a Hash Computed Column for Many Columns?
42) sql-server - Computed field when NULL