SQL Server--怎样用ADO在SQL SERVER中建库，建表

通过ADO可以访问SQL SERVER，并执行相应的SQL语句建库、建表，下面是SQL SERVER BOOKS ONLINE中的相关定义。建表： CREATE TABLE [ database_name.[owner]. | owner. ] table_name ( { | column_name AS computed_column_expression } [,...n] ) [ON {filegroup | DEFAULT} ] [TEXTIMAGE_ON {filegroup | DEFAULT} ] ::= { column_name data_type } [ [ DEFAULT constant_expression ] | [ IDENTITY [(seed, increment ) [NOT FOR REPLICATION] ] ] ] [ ROWGUIDCOL ] [ ] [ ...n] ::= [CONSTRAINT constraint_name] { [ NULL | NOT NULL ] | [ { PRIMARY KEY | UNIQUE } [CLUSTERED | NONCLUSTERED] [WITH FILLFACTOR = fillfactor] [ON {filegroup | DEFAULT} } ] | [ [FOREIGN KEY] REFERENCES ref_table [(ref_column) ] [NOT FOR REPLICATION] ] | CHECK [NOT FOR REPLICATION] (logical_expression) } ::= [CONSTRAINT constraint_name] { [ { PRIMARY KEY | UNIQUE } [ CLUSTERED | NONCLUSTERED] { ( column[,...n] ) } [ WITH FILLFACTOR = fillfactor] [ON {filegroup | DEFAULT} ] ] | FOREIGN KEY [(column[,...n])] REFERENCES ref_table [(ref_column[,...n])] [NOT FOR REPLICATION] | CHECK [NOT FOR REPLICATION] (search_conditions) } 建库： CREATE DATABASE database_name [ ON [PRIMARY] [ [,...n] ] [, [,...n] ] ] [ LOG ON { [,...n]} ] [ FOR LOAD | FOR ATTACH ] ::= ( [ NAME = logical_file_name, ] FILENAME = 'os_file_name' [, SIZE = size] [, MAXSIZE = { max_size | UNLIMITED } ] [, FILEGROWTH = growth_increment] ) [,...n] ::= FILEGROUP filegroup_name [,...n]

　　推荐阅读

　　asp防止刷新功能实现代码

使用说明 1.在要保护的页面顶部加如对AntiRefresh.asp文件的引用如：  2.接着添加调用代码复制代码代码如下: <% Const VarNameDateArr="www_domai_net_App_DataArr" >>>详细阅读

本文标题：SQL Server--怎样用ADO在SQL SERVER中建库，建表

地址：http://www.17bianji.com/kaifa2/ASP/33178.html

1/2 1