Sfrgttk

How do I add a strong "onion flavor" to the biryani (in restaurant style)?

How to modify 'inter arma enim silent leges' to mean 'in a time of crisis, the law falls silent'?

How to typeset a small black square as a binary operator?

What does @ mean in a hostname in DNS configuration?

Use intersection in field calculator

Why is Shelob considered evil?

Given the mapping a = 1, b = 2, ... z = 26, and an encoded message, count the number of ways it can be decoded

How do I write a maintainable, fast, compile-time bit-mask in C++?

Why is Bernie Sanders maximum accepted donation on actblue $5600?

What did Putin say about a US deep state in his state-of-the-nation speech; what has he said in the past?

Why is the meaning of kanji 閑 "leisure"?

Aliased pipeline using head and cut

Buying a "Used" Router

What is formjacking?

What is the name of this perspective and how is it constructed?

When distributing a Linux kernel driver as source code, what's the difference between Proprietary and GPL license?

Why do we divide Permutations to get to Combinations?

How do I handle a blinded enemy which wants to attack someone it's sure is there?

Did the characters in Moving Pictures not know about cameras like Twoflower's?

What does "don't have a baby" imply or mean in this sentence?

How can I differentiate duration vs starting time

Why write a book when there's a movie in my head?

Badly designed reimbursement form. What does that say about the company?

How many copper coins fit inside a cubic foot?

Decode URL encoded characters in inline table valued function?

Inline table-valued function vs inline sqlT-SQL View — How to 'pre-fetch' schema using scalar function, then populate using table queryHow to determine the data type of all fields in a result set in SSDT?CROSS APPLY on Scalar functionWhy scalar valued functions need execute permission rather than select?Table valued function VS Stored procedureCommon TVF in SQL server to get results from differnt schemaTable Valued UDF vs Stored Proc for passing values to a SELECT statementEfficiency of Scalar UDF vs TVFForced serialization on inline table valued function

0

I'm looking for a inline table valued function that decodes URL encoded characters (like %20 for space). reference

I see other functions but haven't seen one that is an inline table valued function. I'm tempted in just writing a bunch of REPLACE statements in a function but I'm wondering if there's a better way.

CREATE FUNCTION dbo.itvfURLDecode

(

    @StringValue VARCHAR(MAX)

)

RETURNS TABLE



AS

RETURN ( 

    SELECT REPLACE(REPLACE(@StringValue,'%2B','+'),'%20',' ') /* etc..*/ AS DecodedValue

)



;WITH cteData AS 

(

    SELECT 'This%2Bis%20a%20test%3C%3E%20ok%3F%20100%25' AS example

)

SELECT 

    example, q.DecodedValue  /* returns: This+is a test<> ok? 100% */

FROM cteData c

CROSS APPLY dbo.itvfURLDecode(example) q

sql-server sql-server-2017

share

asked 3 mins ago

GabeGabe

4281918

add a comment | 

0

I'm looking for a inline table valued function that decodes URL encoded characters (like %20 for space). reference

I see other functions but haven't seen one that is an inline table valued function. I'm tempted in just writing a bunch of REPLACE statements in a function but I'm wondering if there's a better way.

CREATE FUNCTION dbo.itvfURLDecode

(

    @StringValue VARCHAR(MAX)

)

RETURNS TABLE



AS

RETURN ( 

    SELECT REPLACE(REPLACE(@StringValue,'%2B','+'),'%20',' ') /* etc..*/ AS DecodedValue

)



;WITH cteData AS 

(

    SELECT 'This%2Bis%20a%20test%3C%3E%20ok%3F%20100%25' AS example

)

SELECT 

    example, q.DecodedValue  /* returns: This+is a test<> ok? 100% */

FROM cteData c

CROSS APPLY dbo.itvfURLDecode(example) q

sql-server sql-server-2017

share

asked 3 mins ago

GabeGabe

4281918

add a comment | 

I'm looking for a inline table valued function that decodes URL encoded characters (like %20 for space). reference

I see other functions but haven't seen one that is an inline table valued function. I'm tempted in just writing a bunch of REPLACE statements in a function but I'm wondering if there's a better way.

CREATE FUNCTION dbo.itvfURLDecode

(

    @StringValue VARCHAR(MAX)

)

RETURNS TABLE



AS

RETURN ( 

    SELECT REPLACE(REPLACE(@StringValue,'%2B','+'),'%20',' ') /* etc..*/ AS DecodedValue

)



;WITH cteData AS 

(

    SELECT 'This%2Bis%20a%20test%3C%3E%20ok%3F%20100%25' AS example

)

SELECT 

    example, q.DecodedValue  /* returns: This+is a test<> ok? 100% */

FROM cteData c

CROSS APPLY dbo.itvfURLDecode(example) q

sql-server sql-server-2017

share

asked 3 mins ago

GabeGabe

4281918

CREATE FUNCTION dbo.itvfURLDecode

(

    @StringValue VARCHAR(MAX)

)

RETURNS TABLE



AS

RETURN ( 

    SELECT REPLACE(REPLACE(@StringValue,'%2B','+'),'%20',' ') /* etc..*/ AS DecodedValue

)



;WITH cteData AS 

(

    SELECT 'This%2Bis%20a%20test%3C%3E%20ok%3F%20100%25' AS example

)

SELECT 

    example, q.DecodedValue  /* returns: This+is a test<> ok? 100% */

FROM cteData c

CROSS APPLY dbo.itvfURLDecode(example) q

share

asked 3 mins ago

GabeGabe

4281918

share

asked 3 mins ago

GabeGabe

4281918

asked 3 mins ago

GabeGabe

4281918

asked 3 mins ago

GabeGabe

4281918