CodingForums.com - View Single Post

rajdeep01 · 12-24-2012, 08:40 AM

To create 'examples' database on your MSSQL Server you should run the following script:
CREATE DATABASE examples;
USE examples;
CREATE TABLE cars(
id int UNIQUE NOT NULL,
name varchar(40),
year varchar(50),
PRIMARY KEY(id)
);

INSERT INTO cars VALUES(1,'Mercedes','2000');
INSERT INTO cars VALUES(2,'BMW','2004');
INSERT INTO cars VALUES(3,'Audi','2001');

12-24-2012, 08:40 AM	PM User \| #54
rajdeep01 New Coder Join Date: Dec 2012 Posts: 20 Thanks: 0 Thanked 0 Times in 0 Posts	To create 'examples' database on your MSSQL Server you should run the following script: CREATE DATABASE examples; USE examples; CREATE TABLE cars( id int UNIQUE NOT NULL, name varchar(40), year varchar(50), PRIMARY KEY(id) ); INSERT INTO cars VALUES(1,'Mercedes','2000'); INSERT INTO cars VALUES(2,'BMW','2004'); INSERT INTO cars VALUES(3,'Audi','2001');