Database.Guide

Skip to content

Beginners

  • What is a Database?
  • Database Tutorial

SQL

  • SQL Tutorial
  • SQL Reference
  • SQL Joins Tutorial
  • SQL Transactions Tutorial
  • Basic SQL Queries

Categories

  • Azure SQL Edge (17)
  • Database Concepts (99)
  • Database Tools (72)
  • DBMS (9)
  • DuckDB (149)
  • MariaDB (424)
  • Microsoft Access (17)
  • MongoDB (265)
  • MySQL (602)
  • NoSQL (8)
  • Oracle (301)
  • PostgreSQL (480)
  • Redis (210)
  • SQL (697)
  • SQL Server (1,170)
  • SQLite (299)

Tag: computed columns

What is a Computed Column in SQL Server?

Posted on January 30, 2020September 10, 2024 by Ian

In SQL Server, a computed column is a virtual column that uses an expression to calculate its value.

A computed column will typically use data from other columns in its calculation. If data in any of those columns is updated, the computed column will automatically reflect the update in its calculation.

Continue reading →
SQL, SQL Server computed columns, mssql, t-sql, what is

Create a Computed Column in SQL Server using T-SQL

Posted on January 30, 2020February 14, 2020 by Ian

This article demonstrates how to use T-SQL to create a computed column in SQL Server.

A computed column is a virtual column that uses an expression to calculate its value. The expression will typically use data from other columns. A computed column is not physically stored in the table unless it’s marked PERSISTED.

Continue reading →

SQL, SQL Server computed columns, how to, mssql, t-sql
  • «
  • 1
  • 2
  • 3
  • 4

About Database.Guide | Privacy Policy