T-SQL - support control flow (if,loops), SQL - Declarative language for working with relational data, Projection - take subset of the columns , Join - combine tables by come column , Selection - take a subset of rows , Aliases - rename a table or a column heading ( KEYWORD:AS), '+' - Concatenation operator, DISTINCT - Use to eliminate duplicate , NULL - Is a special value that means missing value but it not the same as 0, ORDER BY - it can be ASC or DESC, View - are virtual tables made from others tables, views or joins between them, Sequences - similar to Identity fields, INSERT INTO  - use to inserting data , Truncate - Use to delete rows but it works faster than DELETE , WHERE - specify where we want to make changes(keyword),

BASIC CRUD

על ידי
הדפסה
הטבעה

לוח תוצאות מובילות

סגנון חזותי

אפשרויות

החלף תבנית

האם לשחזר את הנתונים שנשמרו באופן אוטומטי: ?