SELECT *
FROM ::fn_helpcollations()
Here is an example of getting a query to be case sensitive:
select count(*)
from tsfile
where left(digitalphotoloc,2) = 'g:'
collate SQL_Latin1_General_CP1_CS_AS
Software Development, etc.
SELECT *
FROM ::fn_helpcollations()
select count(*)
from tsfile
where left(digitalphotoloc,2) = 'g:'
collate SQL_Latin1_General_CP1_CS_AS
No comments:
Post a Comment