| Author: balamurugan 04 Jul 2008 | Member Level: Gold | Rating:  Points: 3 |
if exist(select * from tablename where username ="value" and date = datevalue ) then
messegebox.show("already entry existed with this date")
end if
|
| Author: Jaya Kumar 04 Jul 2008 | Member Level: Gold | Rating: Points: 2 |
IF EXISTS ( SELECT * FROM Table WHERE User_Name = 'abc' AND Date='01/01/2008')
RAISERROR('already entry existed with this date',16,2)
RETURN
|