Simple MySQL script converted to MSSQL... Help :(

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Simple MySQL script converted to MSSQL... Help :(

Author

Topic

applauz
Starting Member

1 Post

Posted - 2010-07-06 : 13:22:35

Hi there,

I do not know MSSQL and am stuck getting a script converted.

I have this query


 CREATE TABLE 'ecarddb' (  
'id' int(6) NOT NULL auto_increment,  
'confKey' varchar(32) collate latin1_german2_ci NOT NULL,  
'yourname' varchar(32) collate latin1_german2_ci NOT NULL,   
'youremail' varchar(32) collate latin1_german2_ci NOT NULL,   
'friendname' varchar(32) collate latin1_german2_ci NOT NULL,   
'friendemail' varchar(32) collate latin1_german2_ci NOT NULL,   
'greeting' varchar(32) collate latin1_german2_ci NOT NULL,   
'message' varchar(32) collate latin1_german2_ci NOT NULL,   
'ecardnum' varchar(32) collate latin1_german2_ci NOT NULL,       
PRIMARY KEY  ('id')
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1
COLLATE=latin1_german2_ci AUTO_INCREMENT=5 ;

I need to create a PHP file that can be executed with the browser to insert all these fields into my MSSQL Database.

My MSSQL Database is set up and I can connect to it using a php file and using $con = mssql_connect($host,$usernameDB,$passwordDB);

Any help is appreciated.

Thanks!

robvolk
Most Valuable Yak

15732 Posts

Posted - 2010-07-06 : 13:54:48

This should be the SQL Server equivalent:

CREATE TABLE ecarddb (  
id int(6) NOT NULL IDENTITY(5,5),  
confKey varchar(32) collate German_PhoneBook_CI_AS NOT NULL,  
yourname varchar(32) collate German_PhoneBook_CI_AS NOT NULL,   
youremail varchar(32) collate German_PhoneBook_CI_AS NOT NULL,   
friendname varchar(32) collate German_PhoneBook_CI_AS NOT NULL,   
friendemail varchar(32) collate German_PhoneBook_CI_AS NOT NULL,   
greeting varchar(32) collate German_PhoneBook_CI_AS NOT NULL,   
message varchar(32) collate German_PhoneBook_CI_AS NOT NULL,   
ecardnum varchar(32) collate German_PhoneBook_CI_AS NOT NULL,       
CONSTRAINT PK_ecarddb PRIMARY KEY (id)
)

There are other collations for German in case you need accent-insensitive, etc. features. You can find them with the following SQL Server query:

select * from fn_helpcollations() where name like '%german%'

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources