×÷Ϊ±¸Íü°É.ÔÚ»ú·¿ÀïÊäÈëµÄ.
/*CREATE TABLE Student
(Sno CHAR(9) PRIMARY KEY,
Sname CHAR(20) UNIQUE,
Ssex CHAR(2),
Sage SMALLINT,
Sdept CHAR(20)
);*/
/*CREATE TABLE Course
(Cno CHAR(4) PRIMARY KEY,
Cname CHAR(40),
Cpno CHAR(4),
Credit SMALLINT,
FOREIGN KEY (Cpno) REFERENCES Course(Cno)
);*/
/*ALTER TABLE Student ADD S_entrance CHAR;*/
/*ALTER TABLE Student ALTER COLUMN Sage INT;*/
/*ALTER TABLE Course ADD UNIQUE(Cname);*/
/*INSERT
INTO Student (Sno, Sname, Ssex, Sage,Sdept)
VALUES ('200815128', '³Â¶¬', 'ÄÐ', '20', 'IS');*/
/*INSERT
INTO Student (Sno, Sname, Ssex, Sage,Sdept)
VALUES ('200815129', 'Àî·Ò', 'Å®', '20', 'SR');*/
/*INSERT
INTO Student (Sno, Sname, Ssex, Sage,Sdept)
VALUES ('200815130', 'ÑóÑó', 'ÄÐ', '19', 'SR');*/
/*INSERT
INTO Student (Sno, Sname, Ssex, Sage, Sdept)
VALUES ('200815131', 'Î⽨¹ú', 'ÄÐ', '21', 'IS');*/
/*INSERT
INTO Student (Sno, Sname, Ssex, Sage,Sdept)
VALUES ('200815132', '³ÂºÆÄÏ', 'ÄÐ', '20', 'SC');*/
/*INSERT
INTO Student (Sno, Sname, Ssex, Sage, Sdept)
VALUES ('200815133', '´º¶¬', 'Å®', '22', 'SC');*/
UPDATE Student
SET S_entrance = '8'
WHERE S_entrance IS NULL;
SELECT *
from Student
¸Õ¸Õ°²×°µÄÊý¾Ý¿âϵͳ£¬°´ÕÕĬÈϰ²×°µÄ»°£¬ºÜ¿ÉÄÜÔÚ½øÐÐÔ¶³ÌÁ¬½Óʱ±¨´í£¬Í¨³£ÊÇ´íÎó:"ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü¡£ (provider: ÃüÃû¹ÜµÀÌṩ³ÌÐò, error: 40 - ÎÞ·¨´ò¿ªµ½ SQL Server µÄÁ¬½Ó) "ËÑMSDN£¬ÉÏÃæÓÐһƪ»úÆ÷·ÒëµÄÎÄÕ£¬ÊµÔÚÈÃÈËÄÑÒÔÃ÷°×£¬ÏÖÔÚ ......
SQL×¢Èë¹¥»÷ÊǺڿͶÔÊý¾Ý¿â½øÐй¥»÷µÄ³£ÓÃÊÖ¶ÎÖ®Ò»¡£Ëæ×ÅB/SģʽӦÓÿª·¢µÄ·¢Õ¹£¬Ê¹ÓÃÕâÖÖģʽ±àдӦÓóÌÐòµÄ³ÌÐòÔ±Ò²Ô½À´Ô½¶à¡£µ«ÊÇÓÉÓÚ³ÌÐòÔ±µÄˮƽ¼°¾ÑéÒ²²Î²î²»Æë£¬Ï൱´óÒ»²¿·Ö³ÌÐòÔ±ÔÚ±àд´úÂëµÄʱºò£¬Ã»ÓжÔÓû§ÊäÈëÊý¾ÝµÄºÏ·¨ÐÔ½øÐÐÅжϣ¬Ê¹Ó¦ÓóÌÐò´æÔÚ°²È«Òþ»¼¡£Óû§¿ÉÒÔÌá½»Ò»¶ÎÊý¾Ý¿â²éѯ´úÂ룬¸ù¾Ý³ÌÐò ......
ʹÓùý Access µÄÅóÓѶ¼ÖªµÀ£¬Access ÀïÓиö“ÊÇ/·ñ”Êý¾ÝÀàÐÍ£¬ÔÚ SQL Server ÖУ¬Ã»ÓÐÕâ¸öÃû³Æ£¬¶øÊ¹Óà bit¡£ÔÚʹÓùý³ÌÖÐÓм¸µãÐèҪעÒâµÄ£º
£±¡¢bit Óë SQL Server µÄÕûÐͺÍÊý×ÖÊý¾ÝÏàËÆµÄÊý×ÖÊý¾Ý£¬µ« bit ÁÐÖ»ÄÜ´æ´¢ 0 ºÍ 1¡£
£²¡¢ÔÚ²åÈë¡¢ÐÞ¸Ä bit Êý¾Ýʱ£¬Ê¹Óà 0 »ò 1 £¬¶ø²»ÊÇ false »ò true£¬bit ×Ö¶ ......