christoffersen366 (11/8/2016)

---

From SQL Server 2014 onward you can use "sys.fn_hadr_is_primary_replica" instead to determine if the current server is primary.

Jeff Moden (11/16/2016)

---

IMHO, cleaner code if you take the shortcut.

SELECT mychar FROM mydata WHERE mychar LIKE '[[]%'

Laurie Dunn (11/17/2016)

---

This would also work and keep the code simple...

SELECT *

FROM dbo.MyData

WHERE Left(mychar,1)='[';

MMartin1 (11/18/2016)

---

Interesting that SMALLINT will implicitly convert to INT , but INT wont implicitly convert to BIGINT. Is this the case also with a .NET language like C#?

No matter what people say, for most people having a job they enjoy is the most important thing