Something like this?

DECLARE @start DATETIME, @end DATETIME

SET @start = '2004-08-01'

SET @end = GETDATE()

SELECT

  DATEDIFF(yy, @start, @end) AS years

  , DATEDIFF(m, @start, @end) AS months

  , DATEDIFF(d, @start, @end) AS days

And to add to that, why should one particular row be returned as opposed to any other one of those 5 possiblities?

I'm going to be going after my MCSD certification C#, my chosen elective is Designing and Implementing Databases with Microsoft SQL Server 2000, Enterprise Edition - Exam 70-229

Questions:

Will this above...

No, in SQL Server 2000 this is not possible. You will be able to do it in SQL Server 2005 however.

You will have to exmplain a little more what you want to achieve. In what application do you want to display them? What do you mean by multiple rows in...

Adding to the answer above, I am taking a wild guess that you are looking for a way to pad a string with spaces to make it a fixed length....

REFERENCES also gives permission to schemabind views or functions against an object. In SQL Server 2005 I believe it will be used for certain uses with CLR code as well.

For moving them, take a look at my checklist for moving system databases.

Oops, apparantly I didn't read the question properly..

Piggybacking on Phill again:

SELECT [id], [name], OBJECTPROPERTY([id], 'TableIsPinned') Pinned

FROM sysobjects

WHERE xtype = 'U'

Live performance data can be seen in Windows System Monitor in Administrative Tools.

To add to that, this information can also be collected directly from the master.dbo.sysperfinfo table.

As lugang says, by EM lists all databases in the server instance, not just the ones that the user has access to. It uses the stored procedure sp_MSdbuseraccess to do...

I agree, learning C# is definitely not wrong for the future. SQL Server 2005 brings CLR Integration, but you said that you have no immediate plans to upgrade. Still, it...

I am probably considered on of those "set purists". My answer to your challenges is simple; do no use SQL Server as a business logic server, especially not for procedural...

Yes, that is exactly how it works. Anything else would be inefficient to say the least. The pages can (and will) be used for later allocations, so there is no...