Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Variable number of parameters to sql stored procedures
Message
De
24/07/2007 00:17:34
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., Nouvelle Zélande
 
 
À
23/07/2007 23:19:04
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01242588
Message ID:
01243076
Vues:
49
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform