SQL Server has multiple data types e.g. integers, char, varchar, doubles, strings, etc. which are used for keeping specific values. Although built-in data types could… Read More
Tag Archives: DBMS-SQL
1.What do you understand by Adaptive query processing launched in SQL Server? Answer: SQL Server and Azure SQL Database introduce a new generation of query… Read More
Structured Query Language or SQL is a standard database language that is used to create, maintain, destroy, update and retrieve the data from relational databases… Read More
Whenever any value is passed to the variable or column of character data type, the string value has single quotes(”) around them otherwise it will… Read More
While inserting data in tables, sometimes we need to capture insert timestamp in the table. There is a very simple way that we could use… Read More
SQL is a Structured Query Language which is a computer language for storing, manipulating, and retrieving data stored in a relational database. SQL is the… Read More
LENGTH() : This function in MySQL is used to find the string length which is of type bytes. Features : This function is used to… Read More
MySQL Date Data Type : There are various data types that are supported in MySQL. Among them sometimes we need to take DATE data type… Read More
As the name suggests, the auto-commit statement is used to avoid the explicit mention of the commit command after each SQL statement. The commit statement… Read More
CASE() function in MySQL is used to find a value by passing over conditions whenever any condition satisfies the given statement otherwise it returns the… Read More
SECOND() function in MySQL is used to return the second portion of a specified time or date-time value. The first parameter in this function will… Read More
ON DELETE CASCADE constraint is used in MySQL to delete the rows from the child table automatically, when the rows from the parent table are… Read More
AVG() : This function in SQL Server is used to return the average value of the specified expression. Features : This function is used to… Read More
GETUTCDATE() : This function in SQL Server is used to return the UTC date and time of the present database system in a ‘YYYY-MM-DD hh:mm:ss.mmm’… Read More
SYSTEM_USER() function :This function in SQL Server is used to return the current user’s login name. Features : This function is used to find the… Read More
Courses
