T-SQL is Microsoft's version of the generic SQL langauge to be used with, for example, Microsoft SQL Server.
gand maro...is the answer
in some cease both are the same they use query language but in fact the out puts are very deference
An SQL statement is a complete set of clauses which returns a value and ends with a semicolon(;) A statement is made up of several clauses Ex: select * from person where f_name='me'; In this ex ' select * from person where f_name='me';' is the statement and select*, from person, where f_name= are the clauses
A catalog is simple a group of related schema collected together in a defined namespace. While schema is a group of one or more related object collected in a common namespace.
Update and Alter are two SQL (Structured Query Language) commands used for modifying databases. Update statement is used to update existing records in a database. Update is a Data Manipulation Language (DML) statement. Alter SQL command is used to modify, delete or add a column to an existing table in a database. Alter is a Data Definition Language (DDL) statement.Commands that are used to define the structure of a database (database schema) are called DDL statements.
Transact SQL (TSQL)
Use the TSQL backup command to backup an active database.
one of the difference is HQL does not support distinct but SQL supports the distinct in the query
SQL*PLUS is a interface between user and Oracle database. It Provide an environment to use the SQL which is a query language to communicate with oracle database
There is no such thing as SQL Server 2003. Microft released SQL Server 2005 as the next version of SQL Server 2000.
gand maro...is the answer
sql exception which provides information on database access errors where as sql warning provides inforamation on database access warnings.
The difference between Pervasive SQL and MS SQL are slight and of a rather technical nature. To the typical consumer the functionality is very much the same, though performance may vary depending upon the use.
god only knows
datediff
RECORD type works only in PL/SQL. But OBJECT type gets stored in database and can be used in both SQL and PL/SQL (without redefining it in PL/SQL).
Function is must be return the value but procedure cannot be returned, for more information please visit the link : http://youropensource.com