As has been mentioned, if you only have 1 of these in your table, it makes no difference if you use BIT or TINYINT. Both will consume 1 byte. All...

Also, see if this helps explaining further:

http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx

Before looking for SQL Server 7.0, see if this helps:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;261334

http://support.microsoft.com/default.aspx?scid=kb;en-us;818550

Brilliant idea, Adam!!! May I suggest, that we can improve this even further? How about making it generic and use dynamic sql here?

What...

Can you imagine, that I am not allowed to install any spam filter here? I use Outlook 2000 and asked for this spambayes tool. Our network admins said my company...

Dave,

found this in my link library

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

Though it's originally the other way round, it might turn out useful.

And finally:

http://www.handels.gu.se/epc/archive/00002948/01/Nr18_MIB.pdf

A comparison of SQL Server, Oracle and DB2 with Codd's rules....

Can't find the link right now, but I remember some time ago an 18?!? year old German pupil spreading some virus got now a job offering from an Anti-Virus software...

but how does one find them in compiled code?

Too much time and not much else to do, I guess

Also, this and a whole lot more useful informations can be found in the link I've posted above.

See if this helps:

http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx

Drum rolls, please....

http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true

Is this a trick question???

SET-based is a SELECT statement for example, while ROW-based is a cursor.

Well, I don't work in the IT business at all. My main duties are the asset management for our insured persons. So, no position that usually deals with creating enterprise...

AJ,

When I run

USE NORTHWIND

GO

DECLARE @MAX1 FLOAT, @MAX2 FLOAT, @MAX3 FLOAT, @MAX4 FLOAT

SET @MAX1 = (SELECT MAX(UnitPrice) FROM [Order Details])

SET @MAX2 = (SELECT MAX(UnitPrice) FROM [Order Details] WHERE MAX(UnitPrice) < @max1)

I...

There is no such thing as a last record. You might want to consider this:

USE NORTHWIND

GO

SELECT

 (SELECT

   OrderDate

 FROM

  Orders

 WHERE

  OrderID =

   (SELECT MIN(OrderID)

    FROM Orders)) AS First_Order

 ,

 (SELECT

   OrderDate

  FROM

   Orders

  WHERE

  ...