RocketScientist's Miscellaneous Ramblings
posts - 76, comments - 354, trackbacks - 3

SQL Server Stuff

Cold and Un-Calculating

I had to mess around a bit with a calculated column today, and I thought I'd share what I found, 'cause it really ticked me off (which, honestly, doesn't take much). So, you've got a spiffy little calculated column in your database that's been there for a few years, and the table's full of data. Let's say you defined the column similar to this: create table foo { ID int not null IDENTITY(1,1), Radius decimal (7,2), Circumference as (2 * pi() * Radius) } (If you don't know a little basic geometry, we'll never get along). OK, so let's say at some point, you live...

posted @ Thursday, September 25, 2003 7:30 PM | Feedback (1) |

Powered by:
Powered By Subtext Powered By ASP.NET