what is module?
May 8, 2009
Module is a container for types within an individual assembly.
what is Code Access Security?
May 8, 2009
CAS is a security system that allows administrators and developers to control application authorization similar to the way that they have always beend able to authorize users. The following resources can be controled by authorization:
- file system
- registry
- printers
- event logs
what is trigger?
May 8, 2009
A trigger is a special kind of stored procedure that responds to specific events. It is a piece of code attached to a particular table. Unlike sproc, the code in the trigger is automatically run whenever the event(s) that you attached the trigger to occur in the table, without explicitly invoking. The events that a trigger can be attached to are:
- insert
- delete
- update
- a mix and match of any of above.
Triggers can be nested.
Triggers can be recursive.
Triggers can be turned off.
what is a sproc?
May 8, 2009
Stored procedure is just something like a script or batch that is stored in in the database rather than in a separate file. sproc can have input/output parameters and return values.
why use sproc:
- call it
- security
- erpformance
How to:
- create/drop a sproc
- declare parameters
- flow control (if…else)
- case
- return values
- loop with WHILE
- waitfor
- dealing with errors
what is view?
May 8, 2009
A view is nothing more than a stored query, and functions like a table which data are mixed from one base table (or more).
