Any SQL Gurus?

nXPLOSi · #1 05-Oct-2007, 03:11 PM

Hi Guys,

Got a problem on our SQL Database, using SQL Query Analyser I've managed to update a date field with a number, not realising it was a date field at the time.

Now the 90 odd records that have had this update, crash the database. I thought i'd be able to just clear the fields from these accounts, but it doesnt seem to be having any of it, just hanging and crashing.

Anyone got any ideas on how to get around this?

Thanks!

**hbroomhall** · #2 05-Oct-2007, 04:07 PM

Is this SQLserver?

Can you do a simple select on the database without it crashing? (So you can see what that field looks like).

And just *how* do you update a date field with a non-date? It shouldn't be possible.

What is the definition of that field?

Lots of questions.

Harry (who knows SQL but isn't so hot on SQLserver)

nXPLOSi · #3 05-Oct-2007, 04:11 PM

Quote:

“

Originally Posted by hbroomhall

Is this SQLserver?

Can you do a simple select on the database without it crashing? (So you can see what that field looks like).

And just *how* do you update a date field with a non-date? It shouldn't be possible.

What is the definition of that field?

Lots of questions.

Harry (who knows SQL but isn't so hot on SQLserver)

”

It shouldn't be possible your right, and it wasn't! It turnt out to be something else, but with the SQL Developer off sick, I paniced abit.

All sorted now, but thanks for the initial help, much apprecaited

**hbroomhall** · #4 05-Oct-2007, 04:13 PM

Harry.