Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Record rows
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' CREATE TABLE test(ID INT) INSERT INTO test VALUES (1); INSERT INTO test VALUES (1); INSERT INTO test VALUES (1); CREATE TABLE product(ID INT) INSERT INTO product VALUES (1); INSERT INTO product VALUES (1); INSERT INTO product VALUES (1); INSERT INTO product VALUES (1); INSERT INTO product VALUES (1); INSERT INTO product VALUES (1); SELECT * FROM test t LEFT JOIN product p ON t.id = p.id; SELECT * FROM test t RIGHT JOIN product p ON t.id = p.id; SELECT * FROM test t INNER JOIN product p ON t.id = p.id;
run
|
edit
|
history
|
help
0
Mahi
TSql - Unroll inventory transactions and compute daily average
concatenate dates for two distinct cases
Company DB
sql_fb
consecutive_nums_2
EXP 8 q2
SQL Server Mistique!?
PROC How to store the results of a Proc in a Variable
SQL Server - UK Holiday Calendar Example