SQL Server T-SQL

T-SQL

INTRODUCTION TO T-SQL

DML

  1. Select, Insert , Update, Delete

DDL

  1. Create, alter  & drop

Common T-SQL

  1. Variables ( temp data storage
  2. Functions (built-in operations
  3. Control of flow ( decision making constructs )
  4. Syntax
  5. Coding conventions

USING DML STATEMENTS

  1. Where
  2. Like , <
  3. Order by
  4.  

WORKING WITH T-SQL

INTRODUCTION TO DDL

Tags:

Leave a Reply