TRIM unwanted chars from string in SQL

-
It's pretty simple but I didn't know this:
TRIM('.,! ' FROM '# test .')

Comments

Post a Comment

Popular posts from this blog

Error starting SQL Server 2017 service. Error Code 3417 - Fixed

-
It's already a third time I uninstall and install again SQL Server 2017 Dev version on my local computer... It's working fine for few days and than suddenly stop running with Error Code 3417: Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online. I tried many ways to fix this, including security changes on master.mdf and of course full re-install. Until suddenly I saw in MS SQL log file this error before the main error: Error: 2775, Severity: 17, State: 12. The code page 65001 is not supported by the server I went to find this error in Google and I found this article, where the author talked with himself about logs, errors, screenshots and questions about them. Until in the bottom of the article he wrote: Uncheck  Beta: Use Unicode UTF-8 for worldwide language support  in  Control Panel -> Re...
Read more

MongoDB Cloud Cluster Test

-
Today I performed initial basic test of  MongoDB Atlas  - it's MongoDB Cloud Cluster that can use different cloud providers. This process took me something like an hour to get my test system working. It's amaizing timing IMHO. And I'm happy to admit that I succesfully connect this cluster to .Net aplication using MongoDB Official driver - this part was not succeeded around an half a year ago in my previous company. Now I know the problem we faced there - it's incorrect connection string. Only incorrect connection string. And we failed. It's sad.... :-( P.S. As a client I used MongoDB Compass that is free and light but lack of major DBA features and UI. And I'm going to use something more powerfull, like Studio3T that I tried once and was very satisfied.
Read more