INTRODUCTION TO T-SQL
It was developed by Microsoft research.it has various other features which we see in basic SQL.
The T-SQL Language is a superset of the ANSI specifications, it not only implements the required functionality, but it provides much more. It includes a number of programming extensions including variable handling, flow control, looping, and error handling, that allow the developer to write sophisticated logic to be executed on the server. In addition, the T-SQL language includes facilities for controlling access to the data, declaring relational integrity (DRI), and defining business rules to be enforced at the server level.
WHERE WE USE T-SQL?
The Transact SQL Language is the primary interface to the SQL Server database engine which is a product of microsoft. Any time we interact with SQL Server, whether it is through one of the provided administrative tools, a custom application, or through the command line interface ISQL, we are executing SQL statements.
you can download a free version of sql server 2008 R2 Express from http://download.microsoft.com/ which is ideal for learning.
Lets start learning various features of sql server and how we can use it.
It was developed by Microsoft research.it has various other features which we see in basic SQL.
The T-SQL Language is a superset of the ANSI specifications, it not only implements the required functionality, but it provides much more. It includes a number of programming extensions including variable handling, flow control, looping, and error handling, that allow the developer to write sophisticated logic to be executed on the server. In addition, the T-SQL language includes facilities for controlling access to the data, declaring relational integrity (DRI), and defining business rules to be enforced at the server level.
WHERE WE USE T-SQL?
The Transact SQL Language is the primary interface to the SQL Server database engine which is a product of microsoft. Any time we interact with SQL Server, whether it is through one of the provided administrative tools, a custom application, or through the command line interface ISQL, we are executing SQL statements.
you can download a free version of sql server 2008 R2 Express from http://download.microsoft.com/ which is ideal for learning.
Lets start learning various features of sql server and how we can use it.
No comments:
Post a Comment