8
Shouts

Quick way to know all computed columns across tables

published 539 days, 20 hours, 24 minutes ago posted by kinj312kinj312 544 days, 3 hours, 24 minutes ago
Friday, December 02, 2011 2:11:13 PM GMT Monday, November 28, 2011 7:10:40 AM GMT

A computed column in SQL Server is an expression which is based on another column in the same table. Consider the following example create table testtable ( id int, names varchar(100), custid as right('00000'+cast(id as varchar(10)),5) ) GO...

category: Data | clicked: 5 | | source: beyondrelational.com | show counter code
tags: SQL Server, TSQL