Run Code
|
API
|
Code Wall
|
Users
|
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
Please
log in
to post a comment.
REGISTRO_ESTUDIANTES
megha
BTVN_QLDT_TUAN 8
SCHOOL-BUILD
Mala Studentska sve
SQL injection
mysql4
WORK
t
Change
Please log in to post a comment.