in some cease both are the same they use query language but in fact the out puts are very deference
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
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.
Procedural DMLs (Data Manipulation Languages) require the user to specify a sequence of operations to manipulate data, allowing for more control and flexibility in how tasks are executed. In contrast, Declarative DMLs focus on what data to retrieve or manipulate without detailing the steps to achieve it, making them generally easier to use. Examples include SQL for Declarative DMLs, while Procedural DMLs can include languages like PL/SQL or T-SQL. The choice between them often depends on the complexity of the operations and the level of control needed by the developer.
OQL is a database query language(related to ODMG) that is based on SQL and supports the adding, retrieving, querying, and invocation of objects. OQL is a version of the Structured Query Language. A object query language that supports complex data types such as multimedia, spatial, compound documents, etc., that are stored as objects. Standard SQL queries can still be used, and the OQL server process converts the objects into relational views. Sanjay
OQL is a database query language(related to ODMG) that is based on SQL and supports the adding, retrieving, querying, and invocation of objects. OQL is a version of the Structured Query Language. A object query language that supports complex data types such as multimedia, spatial, compound documents, etc., that are stored as objects. Standard SQL queries can still be used, and the OQL server process converts the objects into relational views. Sanjay
T-SQL is Microsoft's version of the generic SQL langauge to be used with, for example, Microsoft SQL Server.
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.
god only knows
datediff
CACHE is multidimensional and postconsonantal database and its supporting scripting
Function is must be return the value but procedure cannot be returned, for more information please visit the link : http://youropensource.com