Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
archu
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' create table part (partNumber int primary key, partDescribtion varchar(50)) insert into part values(1000,'asd') insert into part values(1100,'fundmental of IT') insert into part values(200,'information technology') insert into part values(3200,'.net framework') insert into part values(1500,'routing') insert into part values(300,'interface') insert into part values(4500,'software testing') insert into part values(800,'reverse engineering') insert into part values(900,'methods in c#') insert into part values(2000,'context free grammar') insert into part values(3000,'multiplexing') insert into part values(3500,'operating system') insert into part values(400,'swing') insert into part values(4400,'operators') insert into part values(5000,'asp.net') select * from part
run
|
edit
|
history
|
help
0
MSSQL_Q1
Recursion and cte
ms sql where ,like
Solution 2
SQL query to find difference in text between different rows
Subb7
Employye
SO_20171230_SqlServer
Query to remove the string between two indexes of delimiters
Change