By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,856 Members | 2,164 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,856 IT Pros & Developers. It's quick & easy.

comparision of sql server & mysql

P: n/a
raj
whats the difference betwwen mysql and sql server2000 in terms of using
storedprocedures,stored functions and views.

May 19 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
> whats the difference betwwen mysql and sql server2000 in terms of using
storedprocedures,stored functions and views.

What version of MySQL?


--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
May 19 '06 #2

P: n/a
raj
MYSql 5.0

May 19 '06 #3

P: n/a
> MYSql 5.0

Well, both MySQL 5 and SQL Server 2000 have views/procedures/functions.

SQL Server 2000 has Check Constraints, which MySQL doesn't.

From SQL Server 2000, it's quite easy to extend the server with
stuff that's accessible from TSQL (like COM objects and so on)
in a programming language that supports it.

MySQL uses the standard PSM (Persistent Stored Module) Syntax for
it's procedures and functions, while SQL Server uses T-SQL, a Microsoft
extension to standard SQL.
Is there anything specific that you want to know?
--
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
May 21 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.