Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
NAMES CODE
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' /* Create a table called NAMES */ CREATE TABLE NAMES(Id integer PRIMARY KEY, Name text); /* Create few records in this table */ INSERT INTO NAMES VALUES(1,'Tom=100'); INSERT INTO NAMES VALUES(2,'Lucy=200'); INSERT INTO NAMES VALUES(3,'Frank=300'); INSERT INTO NAMES VALUES(4,'Jane=400'); INSERT INTO NAMES VALUES(5,'Robert=500'); /* Display all the records from the table */ SELECT * FROM NAMES; /* Create a table called CODE */ CREATE TABLE CODE(Id integer PRIMARY KEY, code text); /* Create few records in this table */ INSERT INTO CODE VALUES(1,'AS10'); INSERT INTO CODE VALUES(2,'AS11'); INSERT INTO CODE VALUES(3,'AS12'); INSERT INTO CODE VALUES(4,'AS13'); INSERT INTO CODE VALUES(5,'AS14'); /* Display all the records from the table */ SELECT * FROM CODE; DROP TABLE CODE;
run
|
edit
|
history
|
help
0
TRIGGERS
New_1
Group by
group for team members and winners in sql-server
dbms pracs
SQL_Joins_RankingFunctions
identity
BC160401693
repert
exp 8 XIV