Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
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
Please
log in
to post a comment.
TRANHOANGLONG
P1
Cross Apply vs Inner Join
1512081 QUAN LY DE TAI
employee table
prince46
SQL for beginners( defined with errors while enforcing constraints)
Tucha Alexander DB QA Test Tasks Answers
20181CSE0534
test
Please log in to post a comment.