SQL Server is a client-server RDBMS that uses T-SQL to send requests between a client and SQL Server.Normally, client applications are called as Front-end and SQL Server is regarded as back-end. Users may not interact with SQL Server directly. Instead, they communicate through a GUI application built using Visual Basic, Visual C++, Java, C#, HTML. SQL Server can be deployed on the web via Microsoft Active Server Pages.
Classification of T-SQL Statements
T-SQL statements are classified into three. They are
Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Control Language (DCL)
Data Definition Language
With the help of DDL statements, you can create and alter database objects like Tables, Rules etc like Create Table, Drop Table, Alter Table. We will examine these in a another tutorial.
Data Manipulation Language
DML statements enables you to change data and retrieve information from tables like Select, Insert, Update and Delete
Data Control Langauge
DCL statements allows you to set, change permissions for security purposes like Grant, Deny and Revoke.
In order to apply T-SQL statements, you have to learn SQL syntax. For example, to create a database and a table, you have to apply the syntax for creating the same. For each and every purpose, database operations there are syntaxes. Having said this, now you may ask a question where to apply these syntaxes.
Well. SQL Server provides a tool called SQL Server Query Analyzer with which you can effectively code SQL syntaxes. It supports color coding and lot of other features. Also, SQL Server provides another utility called osql. It runs from the command prompt. That means you can control clients activities from the DOS prompt.