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
Campeonato2DLuizFelipe
NOT NULL field from SELECT INTO
mywall
Task2
Cursor (procedural while)
product_sales
table variables (temporary tables)
Performance test - select vs while - Get all days between two dates.
Department revenue pivot
Table