Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Variable number of parameters to sql stored procedures
Message
From
24/07/2007 00:17:34
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., New Zealand
 
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01242588
Message ID:
01243076
Views:
48
Call me an MS-loyalist, but the functionality just isn't there for many corporations.

I did not call you anything ;-) and I agree that the linux world lacks functionality in some areas- especially the visual tools that DBAs and Sysops have learned to expect in the rich Windows world. But many/most Linux apps now have apache extensions for visual management via a browser. MySQL certainly has a comprehensive set of visual tools.

but I know people who have looked at products like MySQL and just find it lacking.

Rod P wrote an article about MySQL a while ago at a time when it had no Stored Procedures. Rod of course is one of those who says he always uses SPs (as of 2006, anyway) so MySQL without SP is obviously going to lose from that POV. Now MySQL has stored procedures/functions, but as I mentioned earlier they don't assist scalability and don't offer the rich featuresets seen in SQL Server. Meanwhile changes in parameterized query handling in SQL Server have also reduced the scaling advantages and there seems to be some concern about SPs growing in power and annexing the business layer. As always, I assume the truth is somewhere in the middle, not that we'll discover that until a few milliseconds before the next great thing is unleashed upon us. ;-)

FWIW, selection of database hasn't been an issue for me since about 2000(?) when I persuaded a customer to move to SQL Server from another flaky C/S system. We're using both MySQL and SQL Server in the office today.
"... They ne'er cared for us
yet: suffer us to famish, and their store-houses
crammed with grain; make edicts for usury, to
support usurers; repeal daily any wholesome act
established against the rich, and provide more
piercing statutes daily, to chain up and restrain
the poor. If the wars eat us not up, they will; and
there's all the love they bear us.
"
-- Shakespeare: Coriolanus, Act 1, scene 1
Previous
Reply
Map
View

Click here to load this message in the networking platform