You cant use IF / ELSE in DML queries.

You can use CASE / THEN / ELSE instead:

update test set REC_HHMMSSHS

= CASE

WHEN exists(select cast(cast(abs(round(cast( left(cast(REC_HHMMSSHS as char(8)) , 2) as int)-1...

I vote for virtual machine!

Sun VirtualBox if possible.

Benefits:

1) No expense

2) You can take snapshots and revert to previous state when something wrong is done (and it will happen...)

3) You can...

If you have to rollback the transaction you will have to do it in the same job step.

Italy played really bad in the confederations cup, but I didn't find...

In fact this is one of the weaknesses of this strategy.

There's no technical solution to this issue: when a user wants to display a 1 mln rows report, we...

Thanks, I would really appreciate it.

DBCC CHECKDB runs againt master and tempdb with no errors. I wouldn't say it fails, I would say it doesn't behave exactly as you expect.

It's hard to give an advice without having the whole picture.

I suggest you take a look at this article http://www.sqlservercentral.com/articles/SQLServerCentral/66909/ and provide as much information as you can.

Regards

Gianluca

It depends on what you have to do with errors. If you want to perform some particular action in case of error, you can hanlde it directly in the sql...

There's no asynchronous transaction feature. You can process commands asynchronously with a queue table and return controlo to the application as soon as you have populated the queue table.

Varchar(max) is a replacement for old-style LOB type text.

If you set 'large value types out of row' to OFF with sp_tableoption you will end up having 8000 bytes stored...

You can return an integer value from a stored procedure:

CREATE PROCEDURE usp_doSomeStuff(@param1 as int)

AS

BEGIN

SELECT SomeColumns FROM SomeTable

RETURN @@ROWCOUNT

END

EXEC @totalRows = usp_doSomeStuff

Don't...

Crystal Reports is a pain.

That said, I have struggled a lot in the past to find myself the best way to feed it the data to display.

If you use stored...

Thanks Barry,

I sent you a PM with the article attached.

Gianluca

Matt Miller (8/14/2009)

---

If you want to insert one row at a time AND get as many in as you can - EACH has to be in its own TRY/CATCH block....

I can't believe it! I'm almost finished with my article!

It took me three months. I could have written the "Divina Commedia" in this time...

Is anybody interested in reviewing my...