首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > SQL Server >

Sqlserver菜鸟

2012-04-05 
Sqlserver初学者我刚接触这个数据库,现在老师上课讲到创建表,,有两种方法,一种直接什么。。。还有就是用sql语

Sqlserver初学者
我刚接触这个数据库,现在老师上课讲到创建表,,有两种方法,一种直接什么。。。还有就是用sql语句,我看第一句中方法很方便,为什么还要学习第二种,虽然现在还没开始学习第二种方法,

[解决办法]
第一种是手工操作,通过微软件提供的工具创建.
第二种是SQL语句操作,一般是在程序中使用.所以如果是软件开发人员,应该掌握这种方法.
其相关内容见下:

SQL code
CREATE TABLE创建新表。语法CREATE TABLE    [ database_name.[ owner ] .| owner.] table_name    ( { < column_definition >        | column_name AS computed_column_expression        | < table_constraint > ::= [ CONSTRAINT constraint_name ] }            | [ { PRIMARY KEY | UNIQUE } [ ,...n ]    ) [ ON { filegroup | DEFAULT } ] [ TEXTIMAGE_ON { filegroup | DEFAULT } ] < column_definition > ::= { column_name data_type }    [ COLLATE < collation_name > ]    [ [ DEFAULT constant_expression ]        | [ IDENTITY [ ( seed , increment ) [ NOT FOR REPLICATION ] ] ]    ]     [ ROWGUIDCOL]    [ < column_constraint > ] [ ...n ] < column_constraint > ::= [ CONSTRAINT constraint_name ]    { [ NULL | NOT NULL ]        | [ { PRIMARY KEY | UNIQUE }            [ CLUSTERED | NONCLUSTERED ]            [ WITH FILLFACTOR = fillfactor ]            [ON {filegroup | DEFAULT} ] ]        ]         | [ [ FOREIGN KEY ]            REFERENCES ref_table [ ( ref_column ) ]            [ ON DELETE { CASCADE | NO ACTION } ]            [ ON UPDATE { CASCADE | NO ACTION } ]            [ NOT FOR REPLICATION ]        ]         | CHECK [ NOT FOR REPLICATION ]        ( logical_expression )     } < table_constraint > ::= [ CONSTRAINT constraint_name ]    { [ { PRIMARY KEY | UNIQUE }        [ CLUSTERED | NONCLUSTERED ]        { ( column [ ASC | DESC ] [ ,...n ] ) }        [ WITH FILLFACTOR = fillfactor ]        [ ON { filegroup | DEFAULT } ]    ]     | FOREIGN KEY        [ ( column [ ,...n ] ) ]        REFERENCES ref_table [ ( ref_column [ ,...n ] ) ]        [ ON DELETE { CASCADE | NO ACTION } ]        [ ON UPDATE { CASCADE | NO ACTION } ]        [ NOT FOR REPLICATION ]    | CHECK [ NOT FOR REPLICATION ]        ( search_conditions )     }
[解决办法]
探讨
大哥好强大啊

热点排行