tag

home / developersection / tag

Explain the SQL triggers and their uses
mssql server 08-Jul-2024
Explain the SQL triggers and their uses

SQL triggers are powerful tools for enforcing rules, auditing changes, automating tasks, and maintaining data integrity within a database system.

Explain the SQL Server backups and their types
mssql server 04-Jul-2024
Explain the SQL Server backups and their types

Database backups are essential for protecting data and ensuring recoverability in case of failures or disasters.

SQL INSERT Mastery: The Definitive Guide to INSERT IF NOT EXISTS (With Examples)
mysql 20-Dec-2023
SQL INSERT Mastery: The Definitive Guide to INSERT IF NOT EXISTS (With Examples)

Learn SQL INSERT Mastery: The Definitive Guide to INSERT IF NOT EXISTS (With Examples) in this article

SQL for Data Analytics: Querying and Manipulating Databases
mysql 18-Sep-2023
SQL for Data Analytics: Querying and Manipulating Databases

Learn SQL for Data Analytics: Querying and Manipulating Databases in this article

Role of SQL (Structured Query Language) in database management
Role of SQL (Structured Query Language) in database management

Learn Role of SQL (Structured Query Language) in database management in this article

What is SQL Injection (SQLi) & How to Prevent It
sqlite 17-Jan-2020
What is SQL Injection (SQLi) & How to Prevent It

When the concept of Database brought to the web it drastically changed the future of the web and brought many opportunities for the web-developers, but at the s

SQL Jobs in London | SQL Jobs in Cambridge
mysql 19-Jul-2019
SQL Jobs in London | SQL Jobs in Cambridge

IT Job Board No #1 Top Rates website in UK.

Types of keys in SQL or Oracle Database.
database 10-Sep-2018
Types of keys in SQL or Oracle Database.

Key plays an important role in SQL or Oracle database. Generally it is used for defining a unique set of records. It also establishes the connection (link) between more than one table.

how to copy data and structure from a table in sql server
mssql server 12-Jul-2018
how to copy data and structure from a table in sql server

In this article we are going to how to copy an existing table to new table in SQL Server with an example.

subquery in sql with example
mssql server 12-Jul-2018
subquery in sql with example

In this article we are going to explain what is subquery in SQL or how to create subquery in SQL or how to use subquery in SQL server with example.

create a simple cursor in sql server
mssql server 11-Jul-2018
create a simple cursor in sql server

In this article we are going to explain what is Cursor in sql or how to create Cursor in sql or how to use Cursor in sql server with example.

Multi-statement Table-Valued User-Defined Function in SQL Server
mssql server 10-Jul-2018
Multi-statement Table-Valued User-Defined Function in SQL Server

In this article we are going to explain what is Multi-statement Table-Valued User-Defined Function in sql or how to create Multi-statement Table-Valued User-Defined Function in sql or how to use Multi-statement Table-Valued User-Defined Function in sql server with example.