Create A Database in SQL Server using SQL Query

USE [master]
GO

/****** Object:  Database [EmployeeDB]    Script Date: 07/05/2012 01:10:26 ******/
IF  EXISTS (SELECT name FROM sys.databases WHERE name = N'EmployeeDB')
DROP DATABASE [EmployeeDB]
GO


/****** Object:  Database [EmployeeDB]    Script Date: 07/05/2012 01:10:26 ******/
CREATE DATABASE [EmployeeDB]
GO

USE [EmployeeDB]
GO

/****** Object:  Table [dbo].[Employee]    Script Date: 07/05/2012 01:12:10 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Employee](
    [ID] [bigint] IDENTITY(1,1) NOT NULL,
    [EmployeeCode] [varchar](max) NOT NULL,
    [EmployeeName] [varchar](max) NOT NULL,
    [DepartmentId] [int] NOT NULL,
    [DepartmentName] [varchar](max) NOT NULL,
    [EmployeeGroup] [varchar](max) NOT NULL,
    [Email] [varchar](max) NOT NULL,
    [isActive] [bit] NOT NULL,
 CONSTRAINT [PK_Employee] PRIMARY KEY CLUSTERED
(
    [ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO
 
 /****** Object:  Employee    Script Date: 7/5/2012 1:26:50 AM ******/
SET NOCOUNT ON
INSERT INTO [Employee] ([EmployeeCode], [EmployeeName], [DepartmentId], [DepartmentName], [EmployeeGroup], [Email], [isActive])
VALUES ('123561', 'Shravan', 5, 'IT', 'Admin','shravanr@xyz.com', 1)
INSERT INTO [Employee] ([EmployeeCode], [EmployeeName], [DepartmentId], [DepartmentName], [EmployeeGroup], [Email], [isActive])
VALUES ('766423', 'Naveen', 2, 'Marketinng', 'User','naveen@xyz.com', 1)
INSERT INTO [Employee] ([EmployeeCode], [EmployeeName], [DepartmentId], [DepartmentName], [EmployeeGroup], [Email], [isActive])
VALUES ('956766', 'Manikanta', 1,'Sales', 'User','manikanta@xyz.com', 0)
INSERT INTO [Employee] ([EmployeeCode], [EmployeeName], [DepartmentId], [DepartmentName], [EmployeeGroup], [Email], [isActive])
VALUES ('868391', 'Rahul', 3, 'IT', 'Super User','rahul@xyz.com', 1)
INSERT INTO [Employee] ([EmployeeCode], [EmployeeName], [DepartmentId], [DepartmentName], [EmployeeGroup], [Email], [isActive])
VALUES ('233189', 'Swaroop', 1, 'IT', 'Admin','swaroop@xyz.com', 1)