SQL server Database auto backup

SQL Database auto backup

I want to discus about SQL server Database auto backup. Agent Activation Code:

For Active SQL Server Agent service: Note To do this, click Start, click Run, and then type services.msc. Then go to: You locate the SQL Server Agent service and then try to start the service. Try This: Thanks a lot for […]

Continue reading


SQL Introduction

SQL Basic Concept

I want to discuss about SQL Introduction for beginners. SQL is Structured Query language. SQL is an ANSI (American National Standards Institute) standard. There are 4 categories in SQL command: Data Definition language (DDL) Data Manipulation Language (DML) Data Control Language(DCL) Transaction Control(TCL) Data Definition language :   CREATE, ALTER, RENAME, DROP Data Manipulation Language :  […]

Continue reading


SQL Constraints

SQL Constraints

I want to discuss about SQL Constraints. Column level constraints : limits only column data Table level constraints : limits whole table data Common types of constraints include the following: NOT NULL Constraint: Ensures that a column cannot have NULL value. DEFAULT Constraint: Provides a default value for a column when none is specified. UNIQUE […]

Continue reading


Sql DateTime

Sql DateTime

In this article we discus about SQL DateTime Format. SQL Server provides a number of options you can use to SQL DateTime Format. One of the first considerations is the actual date/time needed. The most common is the current date/time using getdate(). This provides the current date and time according to the server providing the […]

Continue reading


SQL Basic Query

SQL Basic Query

I want to discuss about SQL Basic Query. Microsoft SQL and Oracle PLSQL is import for DB sql query. SQL queries can be written in the box located under the “Execute SQL” tab. Click ‘Run SQL’ to execute the query in the box.

We have capitalized the words SELECT and FROM because they are […]

Continue reading