Definitions Help

Question

Definitions Help

rocky_498

SSCertifiable

Points: 6532
More actions
January 26, 2010 at 10:18 pm

#219977

Hi all,
I am new in sql area. I am looking any web site or some one have definitions of Primary Key, Foreign Key, Difference between Primary Key and Foreign Key, Trigger, Store procedure,View and many more. Please Please Please pass it out. I tried MSDN and google but I didn't find any good material. Please guide me. Thanks in advance.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 1

My recommendation would be to do a search for a thing called "Books Online". It's the free help system that comes with SQL Server. It contains all of that information and much more.

--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)

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 2

Like this...

http://tinyurl.com/yd47o3d

--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)

vstitte SSCarpal Tunnel Points: 4475 More actions · Answer 3

Jeff,

It will be cool to have this tinyurl thing added to the Reply toolbar. I can see this being used umpteen times to show people how to use Google to search something.