Sql Server is quite selecty!
I got this during chat completely unrelated to SQL Server.
Zebra Ultra says: i love microsoft’s sql server Zebra Ultra says: it is quite selecty zebra ultra
Yup, it’s one of those days.
Archive for the 'Database' Category
MySQL Triggers: How do you abort an INSERT, UPDATE or DELETE with a trigger?
On EfNet’s #mysql someone asked:
How do I make a trigger abort the operation if my business rule fails?
In MySQL 5.0 and 5.1 you need to resort to some trickery to make a trigger fail and deliver a meaningful error message. The MySQL Stored Procedure FAQ says this about error handling:
[…]
Is MySQL the model 21st-century company?
MySQL: Workers in 25 countries with no HQ This open-source software maker has figured out how to manage a world-wide workforce that rarely meets. Is MySQL the model 21st-century company? http://money.cnn.com/
I posted this hastily yesterday, just a bit of tidying up today (2006-06-03).
Solving Soduku with T-SQL
Found this interesting article about solving Soduku with SQL and had to share it. I’d really like to see this implemented with MySQL Stored Procedures and Functions for a good compare/contrast. If you do it, let me know.
Using FireFox Keyword Searches for MySQL Documentation
I answer questions on IRC every day… most questions can be answered by searching the manual. I personally search the manual about 5-10 times per day. I’d suggest that every MySQL users create a FireFox keyword search for the manual an save themselves some trouble.
Navigate to http://dev.mysql.com/doc/ and choose […]
What are relationships in SQL? An IRC perspective.
IRC never fails to amuse me. . .
Don’t use stored procedures yet? So what?
I think most people arguing about stored procedures are missing the point. The most important aspect revolves around a clear separation of concerns.“At just about every talk I give I always try to make several consistent statements. One of which is: ‘Whenever possible use stored procedures to access your data’.” - Rob Howard’s Blog “Let […]