Structured Query Language (SQL) is a widely-used programming language that allows users to interact...
Category - SQL
C# .NET Web Application Tech Stack: Choosing a Database
Choosing a database for a C# .NET web application is an important decision as it affects the...
How to search using a stored procedure in PHP
To search using a stored procedure in PHP, you can use the mysqli_query function to call the stored...
SQL Query Examples with Answers
What is SQL? History of SQL IBM began a major research project in the early 1970s called System/R...
Single-Row Functions in Oracle SQL with Examples
Single row function in SQL are the ones who work on a single row and return one output per row...
How to Select records using StoredProcedure and GridView in asp.net
How to select records using StoredProcedure and GridView in asp.net <%@ Page Language="C#"...
How do I connect to MySQL using ODBC driver?
You can use Microsoft Excel to access data from a MySQL database using ODBC connector. With ODBC...
What are the different types of SQL joins explained with examples?
When working with databases, SQL joins (Structured Query Language table joins) are used to...
Composite indexes – When should you use them in MySQL?
What are composite indexes? Database engines (e.g. MySQL, PostgreSQL, etc.) can create composite...
Using Random Numbers in MySQL
Although you might not expect it, random numbers are used in databases quite often, especially when...
MySQL generate random number not IN table
In an application I made last week, I needed a random id value that was not registered in the...
MySQL Create Database Query
In MySQL, we create a database using the CREATE DATABASE statement. MySQL implements a database as...
SQL Mirroring, Preserving the Log Chain During Database Migrations
Database mirroring has been deprecated since SQL Server version 2012 and now with the advent of SQL...