Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Lisber-SQL-Example(CASE)
SELECT a.* INTO #lisber FROM ( SELECT 1 as 'id' UNION ALL SELECT 0 as 'id' UNION ALL SELECT 0 as 'id' UNION ALL SELECT 1 as 'id' UNION ALL SELECT 1 as 'id' UNION ALL SELECT 1 as 'id' UNION ALL SELECT 1 as 'id' UNION ALL SELECT 0 as 'id' UNION ALL SELECT 0 as 'id' UNION ALL SELECT 0 as 'id' UNION ALL SELECT 1 as 'id' UNION ALL SELECT 0 as 'id' UNION ALL SELECT 1 as 'id' UNION ALL SELECT 0 as 'id' UNION ALL SELECT 1 as 'id' UNION ALL SELECT 0 as 'id' UNION ALL SELECT 1 as 'id' ) as a SELECT CASE a.id WHEN 0 THEN a.id+2 WHEN 1 THEN a.id+3 END as 'changedId' FROM #lisber a DROP TABLE #lisber
run
|
edit
|
history
|
help
0
sql to search database objects' definitions for text
SO 51804194 : sql-recursive-cte-replace-statement-too-slow
Print 10 records
SQL - Find series of timestamps with small gaps
how-to-assign-a-random-value-in-a-select-statement-in-sqlserver
Exam_1
Xml Excercise 1
employee table
Doc
Hack_this