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
Studiu Individual 1
New
A more controllable random string generator function for SQL Server
NAMES CODE
sql 7
employee table
sql server dynamic 12 month time series and pivot with month year column names
TRANHOANGLONG
Update Temp table to Insert node in XML data using SQL
Table