Database

declare @testdata xml
set @testdata = 
'<Root>
<element>1212</element>
<element>1122</element>
<element>1123</element>
<element>1124</element>
</Root>'
SELECT @testdata.query('for $e in /Root/element return concat(string($e),'', '')')

select name           [Database], 
       collation_name [Collation], 
       case 
          when collation_name like '%\_CI\_%' escape '\' then 'Case insensitive'
          when collation_name is null then 'N/A'
          else 'Case sensitive'
       end
from sys.databases;

select sys.tables.name  [Table],
       sys.columns.name [Column],
       collation_name   [Collation], 
       case 
          when sys.columns.collation_name like '%\_CI\_%' escape '\' then 'Case insensitive'
          when sys.columns.collation_name is null then 'N/A'
          else 'Case sensitive'
       end
from sys.tables 
     inner join 
     sys.columns
     on sys.tables.object_id = sys.columns.object_id;

SELECT     COUNT(idstudent) AS IDStudentCount, idstudent,<br />
                          (SELECT     TOP (1) t1.years<br />
                            FROM          myTable AS t1<br />
                            WHERE      (t1.idstudent = myTable.idstudent)) AS Years<br />
FROM         myTable<br />
WHERE     (idvalidat = 2) AND (idmodule = 11)<br />
GROUP BY idstudent<br />
HAVING      (COUNT(idstudent) = 2)

SELECT id_student,
       COUNT(*) as years
FROM   T1
WHERE (id_MODULE=11 )
AND   (id_validat= 2)
GROUP BY id_student
HAVING (COUNT(*) = 2)