Still don't need a cursor for that... but we get your point .

CREATE [unique] CLUSTERED INDEX IX_Whatever ON dbo.TableName (Col, Col2, Col3, Coln)

I can assure you that se was not kidding.  I know a few people like this and their intuition are more than dead on.  If you got the job, it's...

Short and sweet...

Make new DB

SELECT * INTO NewDB.dbo.TblName FROM dbo.CurrentTbl

Backup new databse

Backup currentdb

DELETE dbo.CurrentTbl

Import

This also assumes that you don't have to comply with SOX.

You realize that ALL constraints are disabled by this script.  You better make sure to revalidate all your data before inserting it into the table.

Also doing that will mark the...

You can also browse BOL in the alter table ection to find out what script can disable/enable a constraint (any type).

Like the one of the guy who invented that exemple ?! .

That can also be used as a split function (when the dba doesn't want to have one on the server).  Of course, that works only if you only need to...

Why do you think I can't figure out a usefull way to use that thing???

The only way I could see a good use would be to do a deffered cross-join...

It's possible if you know the Max Depth of the tree... as you can do as many left joins as the max depth requires... but that also has some draw...

UPDATE dbo.YourTable SET Seq = CASE Seq WHEN 1 THEN 2 WHEN 2 THEN 1 ELSE Seq END WHERE Seq IN (1, 2)

Nothing comes to mind.  I have not used mysql in over 3 years (back in school actually) so I never really needed to find one.

Google maybe?

Where do you want to send that new information?

You have to give more details or the answers we'll provide will be extremely generic... at best.

There are not.  Sorry but I can't help you anymore than I did.  Somebody else will catch up with this sometime soon and figure it out.