SELECT DATABASEPROPERTYEX(DB_NAME(), 'Collation') SELECT...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT DATABASEPROPERTYEX(DB_NAME(), 'Collation')

SELECT
    C.collation_name
FROM sys.columns AS C
WHERE 
    C.[object_id] = OBJECT_ID(N'dbo.Posts', 'V')
    AND C.[name] = N'Body';

RETURN

SET STATISTICS IO ON;

-- 48,433,882
SELECT COUNT_BIG(*)
FROM dbo.Posts AS P
WHERE
  1 = 1
  AND LOWER(P.Body COLLATE Latin1_General_100_BIN2) LIKE LOWER(N'%Bananarama%')
  AND P.Body LIKE N'%Bananarama%'
;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results