How to create database in MySQL using PHP?
The CREATE DATABASE statement is used to create database. (Note: Before creating database you must first connect with database server).Here is an example to create database using PHP:
Create database mail profile in sql server step by step.
In this article I would discuss about the Database Mail which is used to send the Email using SQL Server. Database Mail Configuration To Create a D
Create sql server agent job to run stored procedure
This Article describes how to create a Microsoft SQL Server Agent job step that executes Store procedure in SQL Server by using SQL Server Management Studio.
SQLite- Triggers
SQLite Triggers is a sql series of sql statements that are executed automatically to perform/invoked when a specified database event occurs, such as creation or updating record or deletion of record/table.
Glob operator of SQLite Database
In this blog we will learn about SQLite GLOB operator. GLOB operator is used for matching string values against patterns. GLOB operator works like ‘li
AND and OR Operators of SQLite
In this blog we will discuss about SQLite AND and OR operators are that are used to execute multiple conditions to narrow down the selected data in an SQLite statement. Both of these two operators known as conjunctive operators.
SQLite - DETACH DATABASE COMMAND
The DETACH DATABASE statement is used to detach and dissociate a named database from a database connection which was previously attached using ATTACH statement.
SQL View
In this blog describe the concept of sql view in sql server. SQL view is a virtual table. Here we give simple example of view. A View is a Virtual Ta
CURSOR in SQL Server
In this blog describe the concept of cursor in sql server and how to create cursor in sql server, types of cursor. Here, I’m trying to demonstrate the good examples of cursors.
Creating, Inserting, Updating and Deleting in SQLite
In this blog, I’m explaining how to create and use the sqlite database in our application. IntroductionSQLite is a relational database management sy
Locks in SQL Server
In this article, I’m explaining the locks in sql server and its types. Locking helps in providing concurrency within the database. Without locking, S
Checkpoint in SQL Server
In this blog, I’m explaining the checkpoint in sql server. The SQL Server Database Engine automatically executes the CHECKPOINT command to write all