Yeah 

More than one might guess. < vbg >

No, both yield the same result. My version is the ANSI way of doing JOINs, and according to MS preferable to yours.

Btw, normally you would give columns containing the same data the same name throughout the database. Forgot this in my example.

A PRIMARY KEY is a logical construct that is created from one or more columns of your table. You would join on multiple columns like this:

SET NOCOUNT ON

CREATE TABLE master

(

 m1 INT

 ,...

See if this helps: http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0761.mspx

No, this is not possible in SQL Server.

Maybe this will help: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=7956

http://www.sqlservercentral.com/search/turbo.asp Enter "interview question", check "Search Articles" and "Search Discussions"

Lots of useful information for you to explore.

Nah, this is SQL Server's questionable feature to create the Primary Key clustered unless you explicitely state otherwise. While I think this is better than not having a clustered index...

Well, I must confess I use this only for more or less private use. Some 4 or 5 other people in my company use it. I do receive some ~200...

Unless someone else forces me to, I don't want to change my avatar. I was just asking, because it was mentioned in the other thread *and* I was told before,...

If I understand you correctly, you're talking about eMails containing picture attachments which should be loaded into a db, right?

Now, if so, I would write a small VB app utilizing...

Depending on what kind of calculations you perform on your data, MONEY might *not* be the best choice around. Addition and Subtraction is quite okay, however, it gets tricky when...

1: http://www.sqlservercentral.com/columnists/aMachanic/bookreviewofaguidetosqlserver2000transactionalands.asp

2: Anything by Ken Henderson

3: Sorry, no book but look around the site here

4: Database design for mere mortals be Michael J. Hernandez is a good introduction to...

Sorry about that.

You might have a look at UDF's to modularize your code. However, test this *very* carefully if they meet your performance...

Please avoid multi-posting:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=175274