Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mysql´´½¨Êý¾Ý¿âsqlʵÀý

mysql´´½¨Êý¾Ý¿âsqlʵÀý
# MySQL-Front 3.2  (Build 2.10)
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET CHARACTER SET 'latin1' */;
# Host: 192.168.1.7    Database: sohunews
# ------------------------------------------------------
# Server version 5.0.26-community-nt
CREATE DATABASE `sohunews`;
USE `sohunews`;
#
# Table structure for table email
#
CREATE TABLE `email` (
  `emailid` int(11) NOT NULL auto_increment,
  `email` varchar(60) NOT NULL,
  PRIMARY KEY  (`emailid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#
# Table structure for table news
#
CREATE TABLE `news` (
  `newsid` int(11) NOT NULL auto_increment,
  `newstitle` varchar(60) NOT NULL,
  `newsauthor` varchar(20) NOT NULL,
  `newscontent` text NOT NULL,
  `newsurl` char(130) NOT NULL,
  `newsdate` varchar(24) NOT NULL,
  PRIMARY KEY  (`newsid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#
# Table structure for table qq
#
CREATE TABLE `qq` (
  `qqid` int(11) NOT NULL auto_increment,
  `qq` varchar(15) NOT NULL,
  PRIMARY KEY  (`qqid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#
# Table structure for table visitedurl
#
CREATE TABLE `visitedurl` (
  `id` int(11) NOT NULL auto_increment,
  `url` varchar(150) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;


Ïà¹ØÎĵµ£º

ÈçºÎ½« Access Êý¾Ý¿âת»»µ½ SQL Server

http://support.microsoft.com/default.aspx/kb/237980/zh-cn
½« Access Êý¾Ý¿âת»»Îª SQL Server µÄ×î¼ò±ã·½·¨ÊÇʹÓÃÉýǨÏòµ¼¡£ÉýǨÏòµ¼£º
±£ÁôÊý¾Ý¿â½á¹¹£¬°üÀ¨Êý¾Ý¡¢Ë÷ÒýºÍĬÈÏÉèÖá£
×Ô¶¯½« Access ÓÐЧÐÔ¹æÔòºÍĬÈÏÉèÖÃת»»ÎªÊʵ±µÄ SQL Server µÈЧÄÚÈÝ¡£
ÔÚÉýǨºó±£³Ö±í¹ØÏµºÍ²ÎÕÕÍêÕûÐÔ¡£
ÒªÔÚ Access 2000 ......

¾­µäSQLÓï¾ä´óÈ«

ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
¡¡¡¡SQL·ÖÀࣺ
¡¡¡¡DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
¡¡¡¡DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
¡¡¡¡DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
¡¡¡¡Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
¡¡¡¡1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
......

sql server 2005Ö»±¸·ÝÊý¾Ý¿âµÄ½á¹¹

sql server 2005Ö»±¸·ÝÊý¾Ý¿âµÄ½á¹¹
1¡¢´ò¿ªsql server enterpirise management studio£¬ÓÃsaÕÊ»§Á¬½Óµ½Êý¾Ý¿â·þÎñÆ÷¡£
2¡¢Ñ¡ÔñÐèÒª±¸·ÝµÄÊý¾Ý¿â£¬ÓÒ»÷Êó±êÔÚµ¯³öµÄ²Ëµ¥ÖÐÑ¡Ôñ“ÈÎÎñ”——“Éú³É½Å±¾”£¬°´Õսű¾Ïòµ¼£¬ÏÂÒ»²½¾Í¿ÉÒÔÁË¡£
ÕâÑù»á½«´ËÊý¾Ý¿âÖеÄËùÓжÔÏóµÄ´´½¨³ÉÉúÒ»¸ö½Å±¾Î ......

ÔÚXPÉϰ²×°SQL 2000 Server(ժת)

½ñÌì´ÓÍøÂçÉÏÕÒµ½ÁËÔÚXPÉϰ²×°SQL 2000 ServerµÄ·½·¨£¬´ËǰÎÒÒ»Ö±ÈÏΪÕâÊÇÐв»Í¨µÄ£¬ºóÃægoogleÒ»²é£¬»¹ÕæÊÇ¿ÉÒÔ£¬ÓкܶàÍøÕ¾¶¼ËµÕâ¸ö·½·¨¿ÉÐУ¬ÎÒ¾ÍÈÃlpÊÔÊÔ¿´£¬½á¹ûÕæÐУ¬×ªÔØÒ»Ï°ɣº ÔÚWindows XPÉϰ²×°SQL Server 2000µÄÖ÷ÒªÁ÷³ÌΪ£º
Ò»¡¢ÔÚSQL·þÎñÆ÷µÄ°²×°ÅÌÖÐÕÒµ½MSDEÕâ¸öĿ¼£¬²¢ÇÒµã»÷setup.exe°²×°Ëü£¬¹ý³Ì ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ