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
delete all data from given scheme tables
cinema latinoamericano
MyWall
SQL Directives Order of Execution
sqript for print !00 numbers with out loop
FORMAT FUNCTION (New Feature of 2012 sql server)
bvbn
FIGURA5.4
TRANSACTIONS
Alquileres