How do I extract text that lies between two strings?
My initial problem was to extract from a SQL string generated by MySql, all fields. I had a string like…
SQL
Migrate SQLite to MySQL
I’m developing a huge app made with Xamarin Forms in my company. A problem was to create all tables in…
How to use REPLACE() within NTEXT columns in SQL Server
SQL has an incredibly useful function, REPLACE(), which replaces all occurrences of a specified string with another string, returning a…
How can I know when SQL Full Text Index Population is finished?
When you execute some queries on your SQL Server, are you sure the catalog is being imported? With this simple…
How to remove HTML tags from data with SQL
The purpose of this article is to provide a way of cleaning up of HTML tags within the data. When…
SQL SERVER – Find Current Location of Data and Log File of All the Database
As I am doing lots of experiments on my SQL Server test box, I sometime gets too many files in…
How to truncate log file in SQL Server
In SQL Server data is stored using two physical files: (.mdf) extension which contains the data. (.ldf) extension which contains…