Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Demo
CREATE TABLE #Table1 ([Col1] varchar(3), [Col2] varchar(3)) ; INSERT INTO #Table1 ([Col1], [Col2]) VALUES ('1a1', '2b2'), ('11b', '22a') ; SELECT MyNewCol FROM #Table1 CROSS apply(SELECT Col1 WHERE [Col1] LIKE '%a%' UNION ALL SELECT Col2 WHERE [Col2] LIKE '%a%') cs (MyNewCol)
run
|
edit
|
history
|
help
0
sssss
how-to-assign-a-random-value-in-a-select-statement-in-sqlserver
OFFSET FETCH Clause
Tarea1
index fragmentation and how to deal with it
Turn comma-separated numbers in string into rows
updated
6
aa
store1