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.
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.
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.
god only knows
datediff
Function is must be return the value but procedure cannot be returned, for more information please visit the link : http://youropensource.com
in sql commit is used for saving the changes made in database and roll back is to roll back them , changes will not get saved in the database
SQL is a query based language that is used to manipulate data stored in a database while other languages process data.