thxs good and intresting
Type: Posts; User: Alok.Microsoft; Keyword(s):
thxs good and intresting
Indeed, the fact that a view is a relvar is precisely one of the strengths of relational systems; it is important in just the same way as the fact that a subset is a set is important in mathematics....
Views are simply pre-defined SELECT statements against tables in your data model. They are primarily used for simplification of data presentation and to secure your data by only exposing those...
Functions can return value while procedure i mean vb procedures cannot return value
Functions are normally used for computations where as procedures
are normally used for executing business logic.
Functions MUST return a value, procedures doesn't need to.
You can have DML...
A function always returns a value, while a procedure does not. When you call a function you must always assign its value to a variable
The most common reasons for slow database performance are related to one or a combination of issues in these areas:
a. Hardware/os-related causes
b. 3rd party application interference
c....