comparision of sql server & mysql - Microsoft SQL Server

raj

whats the difference betwwen mysql and sql server2000 in terms of using
storedprocedures,stored functions and views.

May 19 '06 #1

Subscribe Post Reply

1428

Martijn Tonies

> 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

raj

MYSql 5.0

May 19 '06 #3

Martijn Tonies

> 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

Similar topics

ASP, ODBC & Cobalt Qube Server....

by: David | last post by:

Hi, Quick question, We have a Cobalt Qube 3 Server running Linux & Chilisoft asp. At the moment my asp applications pull data from the installed MySQL database which is fed data via MS Access...

ASP / Active Server Pages

[MP2] Placing Apache::RequestRec & Apache::RequestIO & APR::Table use statements in startup.pl

by: Jamie Krasnoo | last post by:

Will placing Apache::RequestRec & Apache::RequestIO & APR::Table in startup.pl to load them up for multiple handlers have any bad side effects? I noticed that when I load them via startup.pl the...

MySQL Database

InnoDB & multiple mysqld's on 1 server

by: sean peters | last post by:

Hi all, i've been weighing the pros and cons of running multiple concurrent mysqld's on one server, to have better control over what databases are on what physical disks. System: 4 processor sun...

MySQL Database

My AMP application does not know the mysql data files reside on the same linux server

by: MLH | last post by:

A programmer developed an AMP (Apache/MySQL/PHP) application for me. When he was done, he sent me the PHP files and the MySQL dump file. Now, when I connect to the application on my LAN using...

MySQL Database

Locate folders & files on network server through form....

by: davidgordon | last post by:

Hi, This seems impossible to me. I've read tons of posts, but I just cannot fathom it out. I have a form for our range of products. There are four fields (text) which need to be filled with an...

Microsoft Access / VBA

Case-insensitive comparision of strings

by: kd | last post by:

Hi All, How to perform case-insensitive comparision of strings? Would there be some kind of an indicator, which when set to true, would allow case-insenitive comparision of strings using...

Visual Basic .NET

ODBC & Remote Server Connection Problems

by: dronkanoki | last post by:

I am attempting to set up myODBC 3.51 on Win XP Pro to a remote MySQL Linux server. I get the following error: Access denied for user: 'username@ipaddress.serviceprovider.net' (Using password:...

MySQL Database

& not retrieve from Mysql Database

by: subho2009 | last post by:

Hello friends, I have face a problem, the problem is that when i fetch data from mysql database i get '&' in the place of '&'. I am using php 5.1.2 and mysql version 5.0.11-beta. What is the...

MySQL Database

running web application in MSSQL on server with MySQL; 4CRM SQL & EMS MSSQL Manager L

by: johnyjj2 | last post by:

Hello! I've got web application written in MSSQL and I need to run it on server. But on the server I've go MySQL (not MSSQL), PHP, KFWS. Do I have to install MSSQL and have both MySQL and MSSQL?...

Microsoft SQL Server

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General