Viewing 4 posts - 16 through 19 (of 19 total)
In a real RDMS, you could use cascade deletes but not in Sql Server 2008 (cyclic foreign key bug since sql 2000). Celko refers to Sql Server 2008 as "the...
June 24, 2009 at 11:33 am
Letme guess the error: SQL Server has detected cyclic foreign key cascades?
The only work around is to use a trigger OR USE a database vendor that is much more closer...
June 24, 2009 at 11:18 am
The database is not suppose to format data on the fly, that's not it's job. RDMS are very weak at computational stuff like formatting. This should be handled in the...
June 24, 2009 at 11:13 am
Formatting is a front-end/middle-tier responsibility, why are you doing it in a RDMS where it is slower?
June 24, 2009 at 7:57 am
Viewing 4 posts - 16 through 19 (of 19 total)