Menu
Created a function
CREATE FUNCTION Split_On_Upper_Case(@Temp VARCHAR(1000))
RETURNS VARCHAR(1000)
AS
BEGIN
DECLARE @KeepValues AS VARCHAR(50)
SET @KeepValues='%[^ ][A-Z]%'
WHILE PATINDEX(@KeepValues COLLATE Latin1_General_Bin,@Temp)>0
SET @Temp=STUFF(@Temp,PATINDEX(@KeepValues COLLATE Latin1_General_Bin,@Temp)+1,0,' ')
RETURN @Temp
END
When iam trying to exexute this SELECT Split_On_Upper_Case('SaiBharath') It gives an error "'Split_On_Upper_Case' is not a recognized built-in function name.".Can someone please explain this
309
'AVG' is not a recognized built-in function name." when I try to run the below query. How can I rephrase the AVG(DateDiff) line to calculate this for me? Also, what would this be called so I can do some additional learning on the topic? You need to change your closing parenthesis.
A built-in function is a piece for programming that takes zero or more inputs and returns a value.
SQL Server TRIM() FunctionThe TRIM() function removes the space character OR other specified characters from the start or end of a string. By default, the TRIM() function removes leading and trailing spaces from a string.
Add [dbo] in prefix and then execute as same :
SELECT [dbo].[Split_On_Upper_Case] ('SaiBharath')
To execute function in sql, prefix dbo should be used.
SELECT [dbo].[Split_On_Upper_Case] ('SaiBharath')
Just to make sure, set the database you created your function on first by using the use clause and then prefix the call of your function with dbo.
USE <DatabaseName>
SELECT dbo.Split_On_Upper_Case('camelCase')
Also, a good practice is prefixing each function or database object for that matter, with its schema name.
9
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
