Monday, January 16, 2006

TOP 10 THINGS I HATE ABOUT SQL SERVER

TOP 10 THINGS I HATE ABOUT SQL SERVER: "6. Foreign Keys Constraints !

For some reason, in SQL you can only update or add rows to 1 table at a time! I can do my usual FULL OUTER JOINs with 800 tables together and go nuts with SELECTs all day long, but how about providing that feature for UPDATES and INSERTS!? Otherwise, how can I have referential integrity? If table A needs a matching row in table B, then how the heck do I get them in there at the exact same time? This seems pretty silly to me. "

0 Comments:

Post a Comment

Links to this post:

Create a Link

<< Home