Get Started: SQL Working With Dates

In This Article, You Will Know About SQL Working With Dates. Before moving ahead, let’s know a bit about the SQL CREATE INDEX Statement. Table of Contents Note: Your database date formate should be matched with the date formate you are inserting. SQL Date Data Types Here’s the following MySQL command for inserting a date or … Read more

Get Started: SQL AUTO INCREMENT Field

sql-auto-increment-field

In This Article, You Will Know About SQL AUTO INCREMENT. Before moving ahead, let’s know a bit about the SQL CREATE INDEX Statement. Table of Contents SQL AUTO INCREMENT The SQL AUTO INCREMENT Field is defined as adding up a new number as new data is inserted into the table. Although this work is likely to … Read more

Get Started: SQL CREATE INDEX Statement

In This Article, You Will Know About SQL CREATE INDEX. Before moving ahead, let’s know a bit about the SQL DEFAULT Constraint. Table of Contents CREATE INDEX  The CREATE INDEX statement is used to create indexes in tables. Indexes are just a way to speed up users’ search or queries in the whole database. SQL indexes … Read more

Get Started: SQL Operators

sql-operators

In This Article, You Will Learn About SQL Operators.  SQL Operators – Before moving ahead, let’s know a bit about the SQL Comments. Table of Contents SQL Operators The SQL operators are defined as operators like Arithmetic, Comparison, , and Compound which are used to perform a specific action based on operators. SQL Arithmetic Operators … Read more

Get Started: SQL Comments

sql-comments

In This Article, You Will Know About SQL Comments.  SQL Comments – Before moving ahead, let’s know a bit about the SQL CASE Statement. Table of Contents SQL Comments In SQL Comments are used to represent the statement that will not be executed. It is like an explanation statement to define why an SQL query … Read more

Get Started: SQL Stored Procedures – SQL Server

sql-stored-procedures

In This Article, You Will Know About SQL CASE Statement.  SQL CASE Statement – Before moving ahead, let’s know a bit about the SQL CASE Statement. Table of Contents What is a Stored Procedure? A SQL Store Procedure is a process of saving & storing a code to use it over and over again. If you … Read more

Get Started: SQL NULL Function

In This Article, You Will Know About SQL NULL Function.  SQL NULL Function – Before moving ahead, let’s know a bit about the SQL CASE Statement. Table of Contents SQL NULL Functions The SQL NULL Functions are used to replace the NULL value with another value. Functions are different and work on their usage. Example … Read more

Get Started: SQL CASE Statement

In This Article, You Will Know About SQL CASE Statement.  SQL CASE Statement – Before moving ahead, let’s know a bit about the SQL SELECT INTO Statement. Table of Contents SQL CASE Statement The SQL CASE Statement reads condition step-by-step and return a value when the first condition met TRUE. Once, the condition is TRUE, … Read more

Get Started: SQL INSERT INTO SELECT Statement

In This Article, You Will Know About SQL INSERT INTO SELECT Statement.  SQL INSERT INTO SELECT Statement – Before moving ahead, let’s know a bit about the SQL SELECT INTO Statement. Table of Contents SQL INSERT INTO SELECT Statement The SQL INSERT INTO SELECT Statement is used to copy data from one table and insert … Read more

Stay in the loop

codingstreets