There are many ways to achieve the effect. Here we use the regular expression of Js to process it.
There are many ways to achieve the effect. Here we use the regular expression of Js to process it.
The Code is as follows:
/*
-- Set uppercase letters for the first character string in SQLServer:
-- Author: jinjazz/csdn
-- Enable OLEAutomation in SQLServer2005
Sp_configure 'show advanced options', 1;
Go
RECONFIGURE;
Go
Sp_configure 'ole Automation Procedures ', 1;
Go
RECONFIGURE;
Go
*/
Use tempdb
Go
If (object_id ('fn _ toTitleCase ') is not null)
Drop function dbo. fn_toTitleCase
Go
Create function fn_toTitleCase (@ inStr varchar (8000 ))
Returns varchar (8000)
As
Begin
Declare @ str varchar (8000)
Set @ str = 'var data = "'+ @ inStr + '";
Var reg =/\ B (\ w) | \ s (\ w)/g;
Data = data. toLowerCase ();
Data. replace (reg, function (m) {return m. toUpperCase ()});'
Declare @ object int
Declare @ r varchar (800)
Exec sp_OACreate 'msscriptcontrol. scriptcontrol', @ object output
Exec sp_OASetProperty @ object, 'language ', 'javascript'
Exec sp_OAMethod @ object, 'eval', @ r out, @ str
Return @ r
End
Go
Select dbo. fn_toTitleCase ('create function fn_toTitleCase (@ inStr varchar (8000) returns varchar (8000 )')
/* Output
Create Function Fn_totitlecase (@ Instr Varchar (8000) Returns Varchar (8000)
*/
