JumboZ
05-07-2008, 03:26
minh dang lam mot project de bao cao ve SQL, minh tao tren Table1 cot A1 kieu datetime, yeu cau cua cot A1> Table2.A2 nhung minh tao check constraint thi khong duoc bi thong bao loi
cac ban co the giup minh duoc ko
Minh co y tuong la tao mot triger thay the, minh muon khi khach hang nhap vao A1 < Table2.A2 thi ra cau loi 'Khong Chap Nhan'. minh co tim hieu ham raiserror voi cau truc raiserror('Cau loi',x,y) minh chua hieu ro gia tri x va y nhu the nao, mong cac ban giup minh gap, thu 2 minh phai thuyet trinh,
Cam on cac bban
cac ban co the giup minh duoc ko
Minh co y tuong la tao mot triger thay the, minh muon khi khach hang nhap vao A1 < Table2.A2 thi ra cau loi 'Khong Chap Nhan'. minh co tim hieu ham raiserror voi cau truc raiserror('Cau loi',x,y) minh chua hieu ro gia tri x va y nhu the nao, mong cac ban giup minh gap, thu 2 minh phai thuyet trinh,
Cam on cac bban