Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Add defination in column while create table
-- See total column CREATE TABLE TestTable (ID INT, Value1 INT,Value2 int,Total as Value1+Value2) INSERT INTO TestTable (ID, Value1,Value2) SELECT 1, 10,10 UNION ALL SELECT 2, 20,20 UNION ALL SELECT 3, 30,30 UNION ALL SELECT 4, 40,40 UNION ALL SELECT 5, 50,50 UNION ALL SELECT 6, 60,60 UNION ALL SELECT 7, 70,70 GO SELECT ID, Value1,Value2,Total FROM TestTable
run
|
edit
|
history
|
help
0
La Project
Assignment 1
test
Suikwan tests
h
Movies
CREATE DATABASE
see a quell
MSSQL_Q1
P1