Home / Tag Archives: sql

Tag Archives: sql

Union , Intersect and Except Set Operators

operator

Set Operators : Definition : Set operators are useful in performing the mathematical operations on the data present in the table. There must be at least two select statement so that the operations can be performed on the data by comparing the data from each select statement. Rules to be ...

Read More »

How to create table in SQL database?

create table

Create table in SQL Database. In below article we will see how to create table , delete table, update table and select table in qul database .It is easy to create table in sql. Create Table Command: To create table in the database following syntax is used. Create Table < ...

Read More »

Database Creation In SQL (Structured Query Language)

database creation in SQL

Database Creation  In SQL : In SQL (Structured Query Language) Management Studio we can create the database using commands like below. Database Creation In SQL Database can be created using simple command. Create Database < Database Name > E.g. Create DatabaseMyDatabase Above command will create the “Data File” (i.e. .mdf ...

Read More »

What is SQL and it’s Process?

What is SQL

What is SQL: SQL is a language of database, it includes database creation, deletion, fetching rows and modifying rows etc. SQL is an ANSI (American National Standards Institute) standard but there are many different versions of the SQL language. History: Edgar F. “Ted” Codd of IBM is known as the ...

Read More »

SQL Server Tricks and Help

sql

If Exists command in SQL Server Description: “If Exists” accepts the select statement or any string/number & returns true or false.Sometimes we come across a condition where if some value exists in table we want to perform certain activity. That time we can use “If Exists” clause. Example: Declare @word12 ...

Read More »