Rey

Magician

Rebellion

If you have 9 million rows, int can handle them perfectly. Unless you have a random sequence or something like this that might need to have always 10 digits (even...

Decimal and numeric are synonyms in SQL Server. It doesn't matter if you choose one or the other, although it's a good practice to be consistent.

On the other side, why...

Go to the forum settings http://www.sqlservercentral.com/Forums/EditForumSettings.aspx

And all the way down, there are the date and time settings. Check that you have the correct timezone and play with the checkbox that...

It would be of some help if you post the code you used to grant permissions (with names changed).

It would also help if you post if you got any messages...

First of all, this code seems to be MySQL. This is a SQL Server site, which means that most of us work primarily with that product. I can only give...

N_w (11/1/2016)

---

Hi Luis, thank your for answer.

It's very sad you think my question is a school homework. I'm new in DB world and I set up a linux box at...

Sean Lange (10/31/2016)

---

jasona.work (10/31/2016)

---

Ed Wagner (10/31/2016)

---

Sean Lange (10/31/2016)

---

jasona.work (10/31/2016)

---

ChrisM@Work (10/31/2016)

---

Sean Lange (10/31/2016)

---

ChrisM@Work (10/31/2016)

---

Sean Lange (10/31/2016)

---

Ed Wagner (10/31/2016)

---

ThomasRushton (10/31/2016)

---

Wryan138 (10/30/2016)

---

So in lieu of some marvelous SQL wizardry, I'm just trying to...

Of course, if you're just going to use the second delimiter, a faster approach is available. But I'm sure that you want something more flexible.

ALTER FUNCTION dbo.SubstringIndex2(

...

I might play with some possibilities, but here's an option that doesn't need concatenation.

IF OBJECT_ID('dbo.SubstringIndex') IS NOT NULL

DROP FUNCTION dbo.SubstringIndex

GO

CREATE FUNCTION dbo.SubstringIndex(

...

This sounds a lot like homework and we don't do homework in here.

We can guide you, but you need to give specifics.

Be sure to read the articles on my signature.

You...

Black

Sean Lange (10/31/2016)

---

Thank Luis. I thought...