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, CODE text); /* Create few records in this table */ INSERT INTO NAMES VALUES(1,'Tom=100','AS10'); INSERT INTO NAMES VALUES(2,'Lucy=200','AS11'); INSERT INTO NAMES VALUES(3,'Frank=300','AS12'); INSERT INTO NAMES VALUES(4,'Jane=400','AS13'); INSERT INTO NAMES VALUES(5,'Robert=500','AS14'); /* Display all the records from the table */ SELECT * FROM NAMES;
run
|
edit
|
history
|
help
0
do several updates at once
mhlongothabani99@gmail.com
Update using a temp table
securing critical sections with manual locks in sql server
SQL Problem Template
Status History
OUTPUT CLUASE
code
Names
Database ownership