The UNION part of this really shouldn't make a difference as the results from the two queries are differentiated by the 'Cie1' and 'Cie2' fixed column values.

This means that whatever...

Nice description of a useful but not as simple as it appears topic. Thanks.

Minor thing, the image with the caption "There has been a little movement, as my new files...

Please do not forget non-English installations. This example will not work with them and the environment variables %ProgramFiles% should be used because on non-English systems there may not be a...

• This reply was modified 5 years, 6 months ago by  Nick Ryan.

As this article has been resurrected from the distant past, how about amending the article to show the rather more efficient and slightly more obvious looking use of the MONTH()...

I'll also be very happy when scripting the installation of MS-SQL server is a bit less painful. Controlled installation where are a lot of options and knowing exactly what is...

There's a balance to be had, and a sensible developer/administrator must know and understand the important difference.

An organisation's database is often utterly critical to the operation of the...

I suspect that this is partly down to unofficial standards in software languages. Integer types are usually capable of holding negative numbers whereas word, dword and so on types do...

Sorry, I may be missing something but I was rather confused by this question because the question just reads "how do I add a column to this table" however the...