create table teacher4(
tname varchar(10) NOT NULL ,
tno char(3),
sex char(2)
);
它硬说不支持,,我去掉not null后就可以了,,这是为什么呢??
另,,如何指定主键等一些约束条件呢??
tname varchar(10) NOT NULL ,
tno char(3),
sex char(2)
);
它硬说不支持,,我去掉not null后就可以了,,这是为什么呢??
另,,如何指定主键等一些约束条件呢??
解决方案 »
- 急需大家的帮忙!...谢谢!..
- 从左至由,由上至下的顺序自动设置控件的TabOrder
- 小小修改问题,谢谢给予解决!!!
- 问题严重啊~~~~~~~~~
- 二进制问题:如何根据给出的编码(如UCS2编码)得到sqlserver数据库的varbiny字段的字符串信息
- Dll 报错: raised exception class EOleSysError with message 'CoInitialize 尚未被呼叫.'
- 紧急求助webbrowser的问题
- 为什么strtoDatetime老出错?
- whats wrong?
- Dev Express系列的控件哪儿可以找得到!(jiantao)
- 高难度问题(listview),看看不用第三方控件能否解决?
- 新手上路,初来报到,征集各位的QQ及email,以备随时请教!来者有分
local sql-over view-conventions-unsupported languageThe following SQL-92 language elements are not used in local SQL.ALLOCATE CURSOR (Command)ALLOCATE DESCRIPTOR (Command)ALTER DOMAIN (Command)CASE (Expression)CHECK (Constraint)CLOSE (Command)COALESCE (Expression)COMMIT (Command)CONNECT (Command)CONVERT (Function)CORRESPONDING BY (Expression)CREATE ASSERTION (Command)CREATE CHARACTER SET (Command)CREATE COLLATION (Command)CREATE DOMAIN (Command)CREATE SCHEMA (Command)CREATE TRANSLATION (Command)CREATE VIEW (Command)CROSS JOIN (Relational operator)CURRENT_DATE (Function)CURRENT_TIME (Function)CURRENT_TIMESTAMP (Function)DEALLOCATE DESCRIPTOR (Command)DEALLOCATE PREPARE (Command)DECLARE CURSOR (Command)DECLARE LOCAL TEMPORARY TABLE (Command)DESCRIBE (Command)DISCONNECT (Command)DROP ASSERTION (Command)DROP CHARACTER SET (Command)DROP COLLATION (Command)DROP DOMAIN (Command)DROP SCHEMA (Command) DROP TRANSLATION (Command)DROP VIEW (Command)EXCEPT (Relational operator)EXECUTE (Command)EXECUTE IMMEDIATE (Command)FETCH (Command)FOREIGN KEY (Constraint)GET DESCRIPTOR (Command)GET DIAGNOSTICS (Command)GRANT (Command)INTERSECT (Relational operator)MATCH (Predicate)NATURAL (Relational operator)NULLIF (Expression)OPEN (Command)OVERLAPS (Predicate)PREPARE (Command)REFERENCES (Constraint)REVOKE (Command)ROLLBACK (Command)Row value constructorsSET CATALOG (Command)SET CONNECTION (Command)SET CONSTRAINTS MODE (Command)SET DESCRIPTOR (Command)SET NAMES (Command)SET SCHEMA (Command)SET SESSION AUTHORIZATION (Command)SET TIME ZONE (Command)SET TRANSACTION (Command)TRANSLATE (Function)UNIQUE (Predicate)USING (Relational operator)
d_id char(3) not null,
d_name char(20) not null,
manager char(6),
intro varchar(4000),
constraint department_id primary key(d_id));varchar不能not null?
不太清楚
你可以在查询分析器中,Shift + F1查看关于Create table的帮助,那上面说的很清楚,靠别人告诉你,毕竟是很少,很多东西还是得自己去查找!有些时候,做一些事情不要总是拘泥于一种方法!可以自己多试一些方法,多找一途径,这样你才会进步!