I have to send an empty array.
So, there is a parameter which allows multiple values. It is of type integer. I can send multiple integers as a value of...

The Dixie Flatline (8/4/2016)

---

2) You can use a SEQUENCE to assign unique numbers to all rows across entity tables. That way, if a car row has...

drew.allen (8/4/2016)

---

Boris Pazin (8/4/2016)

---

drew.allen (8/4/2016)

---

There is another approach, but it's a lot more complicated and I would need the information that the others have requested to make a reasonable attempt...

Hey Drew, sequence is interesting idea. I...

It is a little harder, I try different approaches but they mostly look ugly for now. 🙂

Ian Scarlett (8/4/2016)

---

Taking your example of...

Sean Lange (8/4/2016)

---

I can't speak for everybody but seeing a few of the tables definitions would go a LONG way in understanding what it is you are trying to accomplish...

I just tried a query like

SELECT ID, string FROM test

INNER JOIN containstable(test, string, 'C#')

AS KEY_TBL ON test.ID = KEY_TBL.

It is very interesting that it returns correct results on SQL Server...

jethrow (8/18/2013)

---

RegEx would be nice in T-SQL ... but here's an an example implementing what HanShi recommended:

CREATE FUNCTION AlphaNum (@s varchar(100))

RETURNS varchar(100) AS

BEGIN

Declare @n int = PatIndex('%[^A-Z0-9]%', @s-2);

While...

Maybe this could be a reason. Once per...

wolfkillj (8/16/2013)

---

Wait just a sec - the OP asked about using DBCC FREEPROCCACHE but accepted Gail's and Grant's answers that apply to the buffer pool, so I'm confused. Boris, were...

Thanks GilaMonster and Steve for clarifying!

Jobs are done, night has passed, CPU usage is low, website is still fast. I guess it's all good. 😎

Hi Eugene, thanks for response!

It looks like noise words are practically useless.

I can't ask website...