HQL is to perform both select and non-select operations on data, but Criteria is only for selecting data, we can't perform non-select operations using criteria.HQL is suitable for executing static queries, where as Criteria is suitable for dynamic queries.HQL doesn't support pagination concept, but we can achieve pagination with Criteria.Criteria used to take more time to execute than HQL.With Criteria we are safe with SQL injection, because of its dynamic query operation, but in HQL as your queries are either fixed or parametrized , there is no safe for SQL injection.
T-SQL is Microsoft's version of the generic SQL langauge to be used with, for example, Microsoft SQL Server.
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
SQL is a query based language that is used to manipulate data stored in a database while other languages process data.
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
CACHE is multidimensional and postconsonantal database and its supporting scripting