How to Create new database in sql server 2008 / how to get values in datatable

Introduction:

This article is helps to create new database using sql server in 2008/2008 R2.

System databases are Master,Model,msdb,tempdb.

Now create new database for our own way

Method 1:

CREATE DATABASE DATABASENAME

Example:

CREATE DATABASE ASP_DOTNET

GO

Method 2:

Step1:

Database àRight Click à New Database

 Step 2:

Enter database Name and click OK

Step 3:

Create new database then using the such as table ,view, functions and Procedures etc..,