Run Code
|
Code Wall
|
Users
|
Misc
|
Feedback
|
About
|
Login
|
Theme
|
Privacy
String between two indexes
-- Query to remove the string between two indexes of delimiters DECLARE @NameString VARCHAR(MAX) = 'Suman,Saurav,Rajeev,Chandra,Mizan,Ahmed', @StartIndex INT = 0, @EndIndex INT = 21 SELECT STUFF(@NameString, CHARINDEX(',', @NameString, @StartIndex), CHARINDEX(',', @NameString, @EndIndex) - CHARINDEX(',', @NameString, @StartIndex), '')
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
Fatch data in xml format
Test1
Using pre-built schema in sql server
MSQL in 10 mn ~ Lesson 9 Performing Mathematical Calculations - orderitems ~ expanded_price
h
group_concat in sql-server
table variables (temporary tables)
WORK
emp1
prog1
Please log in to post a comment.