So, I’ve been doing a lot of SQL Scripting lately and I’ve come to a stop when I hit a problem I have never hit before. I had to update ColumnA of TblA with ColumnB of TblB. So my initial thought was to do an INNER JOIN UPDATE. So I started typing: UPDATE a
SET a.ColumnA = b.ColumnB
FROM TblA a
INNER JOIN TblB b
And then it hit me. How do I join them? They don’t have any type of relationship. Started thinking and talking to Edgar and decided to use ROW_NUMBER() to join both tables.
UPDATE a
SET a.ColumnA =...
I needed to create a full-text index on a column, but I was unable to do so because of the following error: "Creation of the full-text index is not avaiable. Database is not enabled to allow for full-text indexing." After many hours of searching I found that Full-Text indexing is on by default. Well, not my case. I also found other suggestions of enabling them through the user interface, but I just couldn't find the option. After searching for a while, I found the query for enabling the feature:
EXEC sp_fulltext_database 'enable'
Of course you need to have the desired DB selected or...