Search:

Event can be associated with any objects like it could be textbox, buttons
etc that you use to create the user interface.
Now it's an action that is generated on performing any validations by...

declare @errorCode int
set @errorCode=@@error
if (-@errorCode<>0)
begin
rollback transaction
end
commit transaction

dear

ur question seems to be very obscure.Pls be more specific.

set errorcode to the particular instance of execution and then perform rollback transaction.

use reverse function

select distinct(tblGrades.user),tblGrades.subject,max(tblGrades.Grade)grad
from tblGrades
group by tblgrades.user,tblGrades.subject
order by max(tblGrades.Grade)

u can try this one

select productname from tablename
where purchaseprice like '%980'

There are three levels in a DBMS i.e SQL
a) External
b)Conceptual
c)Internal

I guess ur question might be related to second level i.e conceptual.
For that u can do one thing
type this query...

I am not able to run my web page.
Whenever i try to run a web page it displays an "Server Application error".
Where is the fault.
I am not able to figure it out.
I guess it has to do something...