Ad
Checking Data Type After A Split Operaton In Sql Server
This is my question. I'm receiving a String with values that can be numberic or alphanumeric separated by commas:
'1,2,3,4' or '1,2,b'
My goal is to return another string with this conditions:
Numerica values : Return the same string
Alphanumeric values : Return the values between single quotation and separated by comma '1','2','b'
So far this is the solution that I have:
declare @values nvarchar(max) = '1,2,a', @result nvarchar(max)
set @result = (
select REPLACE(@values, ',', '')
)
begin try
set @result = @result*1
set @result = @values
end try
begin catch
set @result = ( select ''''+ STRING_AGG( value, ''',''') + ''''
from string_split(@values, ','))
end catch
select @result
Is it possible to reach the result without involving a try/catch block? (Request of the arquitect)
Ad
Answer
Just another option (assuming no decimals)
Declare @S varchar(50) = '1,2,3,4'
--Set @S ='1,2,b'
Select case when try_convert(bigint,replace(@S,',','')) is null
then ''''+replace(@S,',',''',''')+''''
else @S
end
Results
'1','2','b'
or
1,2,3,4
Ad
source: stackoverflow.com
Related Questions
- → How to make Laravel use my class instead of native PDO?
- → SQL: simple custom column in select doesn't work?
- → How to execute Stored Procedure from Laravel
- → Which database engine type should be specified for Microsoft SQL Database in Laravel?
- → How to troubleshoot PDOException?
- → laravel sql server stored procedure output
- → Issue with converting a date using Carbon
- → SQL microsoft query to Laravel 4.2
- → General error 20018 Cannot Continue the file execution because the session is in the Kill state
- → List names of all available MS SQL databases on server using python
- → Variable which replace DB of name in SSMS
- → Java: database connection. Where is my mistake?
- → How Can I use "Date" Datatype in sql server?
Ad