Joined: Thu Apr 05, 2007 9:57 pm Posts: 17 Has thanked: 0 time Have thanks: 0 time
ط·آ£ط¢آ¢ط£آ¢أ¢â‚¬ع‘ط¢آ¬ط·آ¢ط¢آ¢ SQL Server has 2 types of Databases : 1. System Tables: Store Information about SQL server as a whole 2. User Tables : Databses that user creates
ط·آ£ط¢آ¢ط£آ¢أ¢â‚¬ع‘ط¢آ¬ط·آ¢ط¢آ¢ Installing SQL Server creates system tables ( as in master DB) and sample user databases such as: (master , model , tempdb , msdb , distribution , pubs and Northwind)
ط·آ£ط¢آ¢ط£آ¢أ¢â‚¬ع‘ط¢آ¬ط·آ¢ط¢آ¢ There are 3 types of statements to use in SQL : 1. DDL Statements : Create and Drop Tables , Views , Indexes and Constarints 3. DML Statements: Insert , Update , Delete and Select from Tables or Views 3. DCL Statements : Create and Drop Users or Roles + Grant and Revoke Privileges 4. DCL Statements .
ط·آ£ط¢آ¢ط£آ¢أ¢â‚¬ع‘ط¢آ¬ط·آ¢ط¢آ¢ Environment of SQL Server: 1. Service Manager : To Start , Stop or Pause Server 2. Enterprise Manager : To do all SQL functions through interface 3. Query Analyzer :To do all SQL functions by hand (writing statements)
DDL Statements
On both Enterprise Manager & Query Analyzer
1.Creating Tables
Used to create a table with a specific structure inside a selected database