Truemag

  • Categories
    • Tips And Tricks
    • Internet
    • PHP
    • Javascript
    • CSharp
    • SQL Server
    • Linux
  • Lastest Videos
  • Our Demos
  • About
  • Contact
  • Home
  • Write With Us
  • Job Request
Home SQL Server MSSQL Create Database With SQL Statement

MSSQL Create Database With SQL Statement

Just an example How to create a new database in Microsoft SQL Server by using SQL statement. Before creating, we need to check whether the database is already exited or not.

USE master
GO
 
---------------------
-- Create database --
---------------------
IF NOT EXISTS (SELECT * 
	   FROM   master..sysdatabases 
	   WHERE  name = N'your_database_name')
	BEGIN
		CREATE DATABASE your_database_name
	END
GO

USE master GO --------------------- -- Create database -- --------------------- IF NOT EXISTS (SELECT * FROM master..sysdatabases WHERE name = N'your_database_name') BEGIN CREATE DATABASE your_database_name END GO

MSSQL Create Database With SQL Statement

MSSQL Create Database With SQL Statement

Feb 17, 2012Hoan Huynh
Firefox How to enable Saved Tabs before closingIE Enable/Disable Proxy Server by using script file
You Might Also Like:
  • How To Track Website With Multiple Google Analytisc Accounts
  • Facebook Like Button And Recommend Button With fb:like, iframe and html5
  • Create Count Down Download Page With JavaScript
  • MSSQL Trim Function
  • JQuery Create Textbox With Count Down Limit Characters
  • Get Image Width Height With JQuery And JavaScript
  • Jquery checkbox checked
  • Javascript Problem Set focus textbox on Firefox
  • MSSQL Split Function returns table data
  • Schedule Backup And Zip MySQL Database In Windows
Hoan Huynh

Hoan Huynh is the founder and head of 4rapiddev.com. Reach him at [email protected]

9 years ago SQL ServerDatabase, Master, sysdatabases228
0
GooglePlus
0
Facebook
0
Twitter
0
Digg
0
Delicious
0
Stumbleupon
0
Linkedin
0
Pinterest
Most Viewed
PHP Download Image Or File From URL
22,485 views
Notepad Plus Plus Compare Plugin
How To Install Compare Text Plugin In Notepad Plus Plus
20,284 views
Microsoft SQL Server 2008 Attach Remove Log
Delete, Shrink, Eliminate Transaction Log .LDF File
16,043 views
JQuery Allow only numeric characters or only alphabet characters in textbox
13,519 views
C# Read Json From URL And Parse/Deserialize Json
10,067 views
4 Rapid Development is a central page that is targeted at newbie and professional programmers, database administrators, system admin, web masters and bloggers.
Recent Posts
  • Online Payday Loans – Learn How To Make the Most of A Alternative Lending Option
  • Strategies For Buying Photo Editor Software
  • Where to Find the Greatest Free Photo Editor on the Web
  • Custom Research Paper – What’s it So Useful?

  • Getting Bad Credit Paydayloans From a Reputable Source
Categories
  • CSharp (45)
  • Facebook Graph API (19)
  • Google API (7)
  • Internet (87)
  • iPhone XCode (8)
  • Javascript (35)
  • Linux (27)
  • MySQL (16)
  • PHP (84)
  • Problem Issue Error (29)
  • Resources (32)
  • SQL Server (25)
  • Timeline (5)
  • Tips And Tricks (141)
  • Uncategorized (247)
Recommended
  • Custom Software Development Company
  • Online Useful Tools
  • Premium Themes
  • VPS
2014 © 4 Rapid Development