Any SQL Gurus?

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

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!

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

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

 

Harry.