Thanks SQLBalls, Jon and ACinKC. That makes it a little clearer. I guess as a beginner I'll understand more as I read more and more of the articles...

No, it won't affect...

Thanks for the beginner's guide, Rob - very much needed in my case! I have one question on this. Are elements and attributes functionally equivalent? For example,...

Of course you do, because it's not 2004 any more.

Here's a third alternative:

WITH Totals(Yr, TotalDueForTheCurrentYear, OverAllTotalDue) AS (

SELECT

YEAR(OrderDate)

,SUM(TotalDue) OVER(PARTITION BY YEAR(OrderDate))

,SUM(TotalDue) OVER(PARTITION BY 1)

FROM

#TestBasedOnYear

)

SELECT DISTINCT

TotalDueForTheCurrentYear

,OverAllTotalDue

FROM

Totals

WHERE

Yr = 2004

John

Not necessarily. Please will you...

You might get misleading results if you have constraints that span more than one column:

CREATE TABLE #john2 (col1 int, col2 int, col3 int)

ALTER TABLE #john2 ADD CONSTRAINT UQ_John2 UNIQUE (col1,col2)

ALTER...

bala.a (9/14/2012)

---

How it's possible to have more than one unique constraint on the same column? Obvoiusly, you should get an error, if I understand your question right....

Could you please provide...

I don't have a script that does exactly what you require, but you could try querying the INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE view.

John

Gail, thanks for pointing that out.

Shobha, have you considered using DBCC CHECKIDENT?

John

The view you are trying to use is only available in SQL Server 2005 onwards. Your database is in SQL Server 2000 compatibility mode. Is there any reason...

Yes, of course I'm serious, and I even took the trouble to explain why. Note that I used the word "consider" - I didn't say it was appropriate for...

I would recommend backing up the databases first, in case the worst happens, which it has done for me before. Given that you have taken a backup, you may...

The top row by what? Age of vehicle? Price of vehicle? Date vehicle added to invoice? Please also provide some table DDL and sample data.

John

Yes, it will - it is likely to cause physical fragmentation on the disk (at least...

You need to understand why the log file grew to the size it is. If it was through normal database activity, then there's no use shrinking since it will...