Difference between T SQL and PL SQL

*

SQL is a query language to operate on sets.

It is more or less standartized, and used by almost all relational database management systems: SQL Server, Oracle, MySQL, PostgreSQL, DB2, Informix, etc.

* PL/SQL is a proprietary procedural language used by Oracle
* TSQL is a proprietary procedural language used by Microsoft in SQL Server.

Procedural languages are designed to extend the SQL's abilities while being able to integrate well with SQL.

They are used to write stored procedures: pieces of code residing on the server to manage complex business rules that are hard or impossible to manage with pure set-based operations.

Procedural Language/Structured Query Language

PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension language for SQL and the Oracle relational database.

You can find more info about PL SQL in bellow link:

http://plsql-tutorial.com/

Validating User Input in ASP.net

* All validation controls are derived from the BaseValidator class
* Validation controls always perform validation checking on the server
* Validation controls also have complete client side implementation that allows browsers that support DHTML to perform validation on the client

Validation controls are:-
RequiredFieldValidator Control
CompareValidator Control
RangeValidator Control
RegularExpressionValidator Control
CustomValidator Control
ValidationSummary Control