Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
sql-server-storing-wildcards-in-data
--Sql Server 2014 Express Edition --Batches are separated by 'go' CREATE TABLE #t (column1 VARCHAR(10) NOT NULL, column2 VARCHAR(10) NOT NULL, column3 VARCHAR(10) NOT NULL); INSERT #t (column1, column2, column3) VALUES ('1','%','2'), ('3','%','%'); SELECT 'first SELECT -- no results'; SELECT * FROM #t WHERE '123' LIKE Column1; SELECT 'second SELECT -- two rows'; SELECT * FROM #t WHERE '123' LIKE Column2; SELECT 'third SELECT -- one row'; SELECT * FROM #t WHERE '123' LIKE Column3;
run
|
edit
|
history
|
help
0
Split name
stackoverflow-54876809-trying-to-get-an-xml-file-into-sql-table
Display Multiple Rows as a single Line
i need help
Hack_this
self join - SQL
Where, And
count events by 2 shift cycles using derived table
Me
emp 4