HOW DO A TRIGGER TO RESTICATE ONLY ONE RECORD IN A TABLE?
This is a multi-part message in MIME format. ------=_NextPart_000_0005_01BE3FCB.72E34300 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: quoted-printable Hi, everybody. I have one question: =20 I have a system table where there is only one record. But sometimes = two or more records are exist in it. I want to create a trigger to = restricate it. How do I create this trigger? Thanks a lot. ------=_NextPart_000_0005_01BE3FCB.72E34300 Content-Type: text/html; charset="gb2312" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN"> <HTML> <HEAD> <META content=3Dtext/html;charset=3Dgb2312 http-equiv=3DContent-Type> <META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR> </HEAD> <BODY bgColor=3D#ffffff> <DIV> <DIV><FONT color=3D#000000 face=3DArial size=3D2>Hi, = everybody.</FONT></DIV> <DIV><FONT color=3D#000000 face=3DArial = size=3D2> =20 I have one question:</FONT> <FONT = size=3D2></FONT></DIV></DIV> <DIV><FONT size=3D2> I have a system table where there is = only one=20 record. But sometimes two or more records are exist in it. I want to = create a=20 trigger to restricate it. How do I create this trigger?</FONT></DIV> <DIV><FONT size=3D2> Thanks a = lot.</FONT></DIV></BODY></HTML> ------=_NextPart_000_0005_01BE3FCB.72E34300--