If you want to seperate values by comma or something here is the solution.
DECLARE @data NVARCHAR(MAX),
SELECT @data = 'abc-abc-abc'
set @delimiter = '-'
DECLARE @textXML XML;
SELECT @textXML = CAST('<d>' + REPLACE(@data, @delimiter, '</d><d>') + '</d>' AS XML);
declare @temp table (num nvarchar(max))
insert into @temp
SELECT T.split.value('.', 'nvarchar(max)') AS data
FROM @textXML.nodes('/d') T (split)
select * from @temp
Recently I was working with search bar in search result page where I encounter below error: Sorry, Something went wrong An error occurred...
Recently I was working on sending mail using smtp server where I stuck on below error: IIS/SMTP - emails are stuck in mailroot/Queue ...
If you want to know which controlled fired post back at page load, here is some sample code. 1) for link button: string ctrlname = Page....