In the INSERT INTO statement tutorial, we have seen how to enter new records into the database tables. You may use column names with VALUES or without Continue Reading
SQL Tutorials
The primary key (or keyword) is used to identify each row in a relational database table. It ensures that the tables do not contain duplicate records. The Continue Reading
The MySQL DATEDIFF function returns the number of days between two given dates. The DATEDIFF takes two arguments as shown in the example below: [crayon-651c34e57d0c9917694909/] Both arguments Continue Reading
We have learned that the INSERT statement is used to enter new records in tables. We also know that the SQL SELECT statement fetches the record-sets from one Continue Reading
The stored procedure is a pre-compiled code of SQL statements that is stored in the database server. The stored procedures enable us writing the programming logic where Continue Reading
The SQL CHARINDEX function is used to return the position of the specified substring in a string. For example, finding the position of ‘@’ in an email Continue Reading
We have learned how to insert data into the SQL databases by using the INSERT command. After inserting data, if you require to change the values in Continue Reading
The SQL SUBSTRING function is used to return a part of the string by specified position. For example: SELECT SUBSTRING('SUBSTRING Examples', 1, 9); In certain scenarios, we Continue Reading
In SQL, the variable is the way of storing a value temporarily. Various types of variables can be declared and used in SQL databases. The variables in Continue Reading
The LIKE operator is used to search column’s data by wildcards. For example: [crayon-651c34e57da6e087723498/] We have used various operators in different queries of SQL. For example, equal Continue Reading
Although, various database servers have tools for creating a table by using GUI/Wizards. There, you may give the database table a name, create columns with data types Continue Reading
The data is stored in the tables in relational database management systems (RDBMS). In order to retrieve data from tables, we use SQL SELECT statement. For example, Continue Reading
While entering or manipulating data in SQL databases, you may require converting data from one type to another. For example, converting a user entered date as string Continue Reading
Generally speaking, the IF..ELSE is a decision making statement in various programming languages. The IF statement is used to execute a block of code if a condition Continue Reading
For returning the date part for a date e.g. day, month, year, hour, minute, second, the day of year etc., use the SQL DATEPART function. The DATEPART Continue Reading