Home / Database (page 2)

Database

Guide about Database Constraints

Constraints

Database Constraints: Constraint is the rules/conditions imposed on the columns & tables to maintain the data integrity of the database. Constraints are of 2 types, Declarative Integrity Constraint: These constraints can be imposed at the time of table or column creation. Procedural Integrity Constraint: These constraints cannot be imposed at ...

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 »

SQL Injection and Preventing SQL Injection

SQL Injection

SQL Injection If you take user input through a webpage and insert it into a SQL database, there’s a chance that you have left yourself wide open for a security issue known as SQL Injection. This lesson will teach you how to help prevent this from happening and help you ...

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 »