Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
w1102157
Yak Posting Veteran
80 Posts |
 Posted - 2012-08-06 : 07:59:46
|
| Hi guys ,Is there any online tutorials based on creating a whole database on sql server 2008?Thank you |
|
|
xhostx
Constraint Violating Yak Guru
277 Posts |
Posted - 2012-08-06 : 08:39:31
|
| your question is a bit vague, creating a database can having a lot of meanings, creating tables...etc, or txt files or Excels....and so on.if you don't need to write a script you can use Enterprise Manager, right click on databases and create one as well as its contents.OR you can use Query Analyzer if you need to develop your database writing SQL scripts.Anyways, be more specific (what you really need )so you can get help quickly.--------------------------Get rich or die trying-------------------------- |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
w1102157
Yak Posting Veteran
80 Posts |
Posted - 2012-08-06 : 10:34:15
|
| XHOSTX, I want an example scenario where I can design and then create a database, create tables, link them together and insert data into these tables |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-06 : 10:45:55
|
quote:
Originally posted by w1102157
XHOSTX, I want an example scenario where I can design and then create a database, create tables, link them together and insert data into these tables
have a look at CREATE DATABASE, CREATE TABLE, ALTER TABLE ADD CONSTRAINT and INSERT statement syntaxes in BOLtry it out yourself and if you face issue post here to get help.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
xhostx
Constraint Violating Yak Guru
277 Posts |
Posted - 2012-08-06 : 11:11:08
|
| this page maybe helpful, this will only help you how to create it graphically, there's little scripts examples provided under a link on this page, BUT it will do the job.http://www.quackit.com/sql_server/tutorial/As visakh16 said, try and read the MSDN doc, it is a very good place to start too.--------------------------Joins are what RDBMS's do for a living |
|
|
|
|
|
|
|
|
Creating database