Database

Select DISTINCT id, name
FROM stud
INNER JOIN dep on stud.depid=dep.depid
LEFT JOIN class on stud.id=class.id
WHERE dep.rid=@rid 
AND stud.id is null

select id,name
from stud s
where not exists
(
    select c.id
    from class c
    where c.id = s.id
)
and depid in
(
    select depid
    from dep
    where rid=@rid
)

Select sum(GTotal) Grand
From(
SELECT
(
    SELECT SUM(GrandTotal) as GTotal
    FROM CompletedOrdersHistory
    WHERE OrderStatus='COMPLETED'
    AND OrderDate >= @StartDate
    AND OrderDate < @StopDate        
)
    UNION ALL
(
    SELECT SUM(GrandTotal) as GTotal
    FROM CompletedOrders
    WHERE OrderStatus='COMPLETED'	
    AND OrderDate >= @StartDate
    AND OrderDate < @StopDate
))

WITH sums AS (
    SELECT SUM(GrandTotal) GrandTotal
    FROM CompletedOrdersHistory
    WHERE OrderStatus='COMPLETED'
    AND OrderDate >= @StartDate
    AND OrderDate < @StopDate        
    UNION ALL
    SELECT SUM(GrandTotal) GrandTotal
    FROM CompletedOrders
    WHERE OrderStatus='COMPLETED'	
    AND OrderDate >= @StartDate
    AND OrderDate < @StopDate
    )
SELECT  Sum(GrandTotal) AS GrandTotal
FROM    sums

Select @id=id from inserted where id=@id

where id=@id

CREATE trigger In_LoaiDG1 on KhaoSat_LoaiDG1 

insert into KhaoSat_LoaiDG1

else
insert into KhaoSat_LoaiDG1(MaLoaiTT,Muc1,NgayDG) values (@MaLoaiTT,1,@NgayDG)

Frygreen wrote:

Another question is: Is it ok to start programming with "basic Ado.Net" and not focussing on EF or Linq?

Frygreen wrote:

It seems, that the express-edition does not have all the tools installed.