how to create master table in sql
-
a
-
??
Not sure what you are looking for with so little information.
-
shashianireddy (1/3/2015)
how to create master tableplz give one example ...
I agree with Lynn. There's just not enough information here. What is this "master table" supposed to do or contain?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Wild guess...
Do you mean a table that will be automatically created in each database? Then create it first in the model database on your system.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
I'm suspecting a student, and thinking he either means:
1) How do you design/create the central production data table of a VERY small database (possibly a one-table db ie Student_Name/Class_Name/Address/phone_number)? ;
or
2) How do I create tables within the Master DB?
Answers:
1) Read up on database design;
2) Don't. Why? Read Answer 1). 🙂
-
shashianireddy (1/3/2015)
aDeleting an original post is a real quick way to lose friends. 😉
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
I think you guys have all been punked.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARantMinion Maintenance is FREE:
-
KenpoDBA (1/5/2015)
I think you guys have all been punked.Oh noes. Not again.
Ha!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
KenpoDBA (1/5/2015)
I think you guys have all been punked.Heh... ok then. Small change...
Punking us is a real quick way to lose friends. 😀
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
KenpoDBA (1/5/2015)
I think you guys have all been punked.Wow, look at that picture from sooo long ago.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
shashianireddy (1/3/2015)
ab
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
SQLRNNR (1/6/2015)
KenpoDBA (1/5/2015)
I think you guys have all been punked.Wow, look at that picture from sooo long ago.
Yeah, he was almost pretty once. Almost.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply