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