Which documents that need to exist depend on the processes and policies that a company is using. For instance, I normally work with agile software development methodologies and we have...

And another one (probably not better though):

SELECT * FROM table1 WHERE NOT EXISTS (SELECT * FROM table2 WHERE id = table1.id AND date_x = table1.date_x)

What exactly do you mean by "database document"? If you are referring to a database diagram then you can use the diagram feature in Enterprise Manager to create one and...

A table created with the ##prefix is a global temporary table. When they are created they exist as long as there is at least one connection referencing it still...

Another thing you should do is try to reproduce it. If possible with a small set of data and a schema you are allowed to show, so that you can...

Yes, I know, I am getting there. It is a difficult question to formulate an answer for, and I should also have gone home from work more than 30 min...

Simple, until the results are in you do not store them. Something like:

TEST { testid , orderdate , orderedby , ... }

TESTRESULT { testid , result }

Until we have a...

>If Middlename = '' then WE KNOW THAT THARE IS NO MIDDLENAME.

I do not agree. You only know that the stored value for middlename is an empty string. What does...

See my article here at SSC for an explanation why that would not do any difference: Advice on using COUNT()

If you are writing your own client you can get the print statements as informational messages. See my blog for more info on getting InfoMessages.

Foreign keys, joins and views are not related subjects. FKs are constraints, used to make protect data integrity. Joins are used to combine rows from different rowsets into a result....

And everything would be much simpler if we had bi-logic (right word?), e.g. nothing other than true/false.

To answer Vladan:

PERSON { id , ... }

NAMEPART { part } (with three tuples...

If you are running it with "Results in Grid" active then the result of SELECT @test-2 will be in the grid, and the two print statements are printed to the...

That was not what I was referring to. In my Regional Settings (I am running Win XP Pro English) I select the Languages tab (not Advanced). There is an option...

But is any of those "many languages" that are displayed correctly written right-to-left? I think the client needs to have the proper language files installed. Check in Control Panel, Regional...