HTSV
https://hotrosinhvien.hufi.edu.vn
hotrosinhvien.hufi.edu.vn
hotrosinhvien.hufi.edu.vn
SELECT TOP(1) ISNULL(tblDepartment.ID,0) AS ID, ISNULL(tblDepartment.Code,'') AS Code,ISNULL(tblDepartment.Name,'') AS Name,
ISNULL(tblDepartment.LinkUrl,'') AS LinkUrl,ISNULL(tblTemplate.Name,'''') AS Template
FROM tblDepartment LEFT OUTER JOIN tblTemplate ON tblTemplate.ID=tblDepartment.ID_Template WHERE tblDepartment.LinkUrl LIKE '%/hotrosinhvien.hufi.edu.vn%' OR tblDepartment.LinkTest LIKE '%hotrosinhvien.hufi.edu.vn%'