Column Default Value

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Will you be updating or directly inserting into c? If not use a calculated column.

DBABC SSCarpal Tunnel Points: 4813 More actions · Answer 2

i wont be directly inserting/updating c,

i will just insert/update a & b only.........

so i want the effect of insert/update in a & b automatically be appeared in c....

How can i use calculated column??

Jack Corbett SSC Guru Points: 184394 More actions · Answer 3

Sorry the real term is computed column. Here is a link about them: http://www.sqlservercentral.com/articles/T-SQL/61764/

Here is some code that demonstrates how they work:

[font="Courier New"]CREATE TABLE #temp

(

first_name VARCHAR(10),

last_name VARCHAR(20),

full_name AS first_name + ' ' + last_name

)

INSERT INTO #temp

SELECT

'Jack',

'Corbett'

SELECT * FROM #temp

UPDATE #temp

SET last_name = 'Corbette'

SELECT * FROM #temp

DROP TABLE #temp

[/font]