|
-
Oct 5th, 2010, 08:18 AM
#1
Thread Starter
Hyperactive Member
[RESOLVED] convert my sql to sql server
i have my sql table
CREATE TABLE 'chat' (
'id' INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
'from' VARCHAR(255) NOT NULL DEFAULT '',
'to' VARCHAR(255) NOT NULL DEFAULT '',
'message' TEXT NOT NULL,
'sent' DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
'recd' INTEGER UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY ('id')
)
ENGINE = InnoDB;
i need to convert in sql server ,i write following script but has some problem
CREATE TABLE chat ('id' int , 'from' varchar(255),'to' varchar(255),'message' text,'sent' datetime,'recd' int)
is there any problem in this
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|