建立表结构的SQL命令是___。 A. CREATE CURSOR B. CREATE TABLE C. CREATE INDEX D. CREATE VIEW 相关知识点: 试题来源: 解析 B 正确答案:B 解析:CREATE TABLE表的定义命令,命令中各短语的功能: PRIMARY KEY:用于定义满足实体完整性的主索引。CHECK…ERROR:用于定义域的完整性和出错提示信息。DEFAULT:用于...
在SQL中,可以用___语句来声明游标。()A.create cursor命令B.alter cursor命令C.set cursor命令D.declare cu
CREATE LOGIN (Transact-SQL) CREATE MASTER KEY (Transact-SQL) CREATE MESSAGE TYPE (Transact-SQL) CREATE PARTITION FUNCTION (Transact-SQL) CREATE PARTITION SCHEME (Transact-SQL) CREATE PROCEDURE (Transact-SQL) CREATE QUEUE (Transact-SQL) CREATE REMOTE SERVICE BINDING (Transact-SQL) ...
对于 Transact-SQL 函数,允许使用除 timestamp 数据类型之外的所有数据类型(包括 CLR 用户定义类型和用户定义表类型)。对于 CLR 函数,允许使用除 text、ntext、image、用户定义表类型和 timestamp 数据类型之外的所有数据类型(包括 CLR 用户定义类型)。不能将非标量类型 cursor 和 table 指定为 Transact-SQL 函数或...
Transact-SQL 语法约定语法SQL Server 和 Azure SQL 数据库中存储过程的 Transact-SQL 语法:syntaxsql 复制 CREATE [ OR ALTER ] { PROC | PROCEDURE } [schema_name.] procedure_name [ ; number ] [ { @parameter_name [ type_schema_name. ] data_type } [ VARYING ] [ NULL ] [ = default ]...
syntaxsql 複製 CREATE [ OR ALTER ] { PROC | PROCEDURE } [schema_name.] procedure_name [ ; number ] [ { @parameter_name [ type_schema_name. ] data_type } [ VARYING ] [ NULL ] [ = default ] [ OUT | OUTPUT | [READONLY] ] [ ,...n ] [ WITH <procedure_option> [ ,......
returned data types include a row type, array type, or cursor type; b) Must be used if the RETURNS TABLE clause specifies any syntax other than a column-list; c) Not supported if RETURNS ROW is specified; d) Not supported when defining a table function in a partitioned database ...
1 The optional clauses can be specified in a different order.SQL-routine-body SQL-control-statementALLOCATE CURSOR-statementALLOCATE DESCRIPTOR-statementALTER FUNCTION-statementALTER MASK-statementALTER PERMISSION-statementALTER PROCEDURE-statementALTER SEQUENCE-statementALTER TABLE-statementALTER TRIGGER-statement...
For more information about SQL Server system data types and their syntax, see Data Types (Transact-SQL). Table-valued or cursor data types can't be used as parameters. If the data type of the parameter is a CLR user-defined type, you must have EXECUTE permission on the type....
For more information about SQL Server system data types and their syntax, see Data Types (Transact-SQL). Table-valued or cursor data types can't be used as parameters. If the data type of the parameter is a CLR user-defined type, you must have EXECUTE permission on the type....