1. Database
Contains objects applied to represent, depositor data, and access data.
2. Tables
Depositor lines or record interacting data one another.
3. Diagrams Data
Graphically presents database, so that manipulation can without having to
Uses command Transact-SQL.
4. Index
Addition files increasing speed of access from table’s line
5. View
Provides way of view data differing from entangles one or more tables.
6. Stored procedure
Programs Transact-sql kept in server to implement duty – duty Which has been determined?
7. Function
Gathering of command containing input or doesn't apply input either one or Multiple and releases value either in the form of scalar and also tabular (be in the form of tables). Ex: function of SUM to add some values. Function Of DATE DIFF for determines difference between two date. Function @@ SERVER NAME for gets name from server. And functions which we are create x' self.
8. Trigger
a type procedure kept and implemented in Event-driven if Certain operation done at tables.
IMPLEMENTS QUERY
Before implementing Query, command SQL which we earn in coequal based on regulation of Syntax with clicks button (√ ) . While to implement applies button ( >).
0 comments:
Post a Comment