Yes, the 2nd is what I have asked.

But the replace

DECLARE @String NVARCHAR(MAX) = N'Lorem DO ipsum BE dolor BO sit amet, consectetur adipiscing elit'
SELECT * 
FROM dbo.STRING_SPLIT(REPLACE(REPLACE(REPLACE(@String,...

Hi folks,

Some words about this interesting function.

Now I call this function like this:

SELECT * FROM dbo.STRING_SPLIT(N'Lorem DO ipsum BE dolor BO sit amet, consectetur adipiscing elit', N'DO');

GO

But what to do...

Try SQLManager.net, it has free products, including

"EMS SQL Manager for PostgreSQL Freeware is a free database tool designed to help DBA effectively manage PostgreSQL environment. The program provides powerful capabilities...

no, it is impossible, try to find another way :w00t:

because I asked about tables # and...

How to count rows in # or ## table ?

Can described approaches be applied to temp tables?

michael.nathan.white (8/17/2009)

---

Ah Grasshopper

Thanks for chiming in. I actually worked out the details of the assembly for the website. I will post the steps later as I think others may want...

Hi Michael,

I am going to use irony-based query parser into webservice.

I do not see any problem to do it.

Regards,

Oleg.

In my opinon the great disadvantage of MS thesaurus implementaion is that sql server does not use forms of thesaurus words.

If user wants to have "full functional synonym" he should...

Hi,

thank you , it is great.

Regards.

Great script.

But need to correct it.

I have 20 databases on one server and 3 are offline for some special pruposes.

This script gives me error and does not work if one...

Hi Mike,

thank you for your answer.

Regards,

Oleg.

marcosc (10/7/2008)

---

Good article.

Actually, with Nautilus [/url]you can find a table just writing part of its name and once located you can find a record writing any word which is...

Steve Jones - Editor (10/7/2008)

---

That's fairly rude of you. The description of the article seems to fit and there are plenty of people...

Hi Mike,

very useful article, especially code - thank you.

I tested code and found one problem.

If I entered phrase:

president -aluminium

it wokrs fine.

If phrase is:

-aluminium president

it generates syntax error, phrase cannot...

Hi,

btw, check http://www.red-gate.com. Thay have tool for managing scripts applying to the many servers and databases.

I hope it can help you.

Regards.