{ DESC | DESCRIBE } [ TABLE ] [ EXTENDED | FORMATTED ] table_name { [ PARTITION clause ] | [ column_name ] } 參數EXTENDED 或FORMATTED 如果指定顯示所指定數據行的詳細資訊,包括命令所收集的數據行統計數據,以及其他元數據資訊(例如架構限定符、擁有者和存取時間)。 table_name 識別要描述的數據表。
__k_SqlDescribeId __k_sqlName_ID __k_strSize_ID __k_tabId_ID arrayFieldHandle fieldIdFieldHandle fieldTypeFieldHandle flagsFieldHandle nameFieldHandle nullableFieldHandle numericPrecisionFieldHandle numericScaleFieldHandle rightJustifyFieldHandle shadowFieldHandle SqlDescribeTableHandle sqlNameFieldHandle ...
SqlDescribeTableHandle sqlNameFieldHandle strSizeFieldHandle tabIdFieldHandle Properties Methods SqlDictionary SqlParameters SqlStatementExecutePermission SqlStatistics SqlStatType SqlStorage SqlSyncInfo SqlSyncLogType SqlSyncMessageType SqlSyncPending SqlSystem ...
为了描述任何 SQL 语句的参数,SQL Server Native Client ODBC 驱动程序在准备好的 ODBC 语句句柄上调用 SQLDescribeParam 时生成和执行 Transact-SQL SELECT 语句。 结果集的元数据确定预定义语句中的参数的特征。 SQLDescribeParam 可以返回 SQLExecute 或 SQLExecDirect 可能返回的任何错误代码。
SQLSetDescField Function SQLSetDescRec Function SQLSetEnvAttr Function SQLSetParam Function SQLSetPos Function SQLSetScrollOptions Function SQLSetStmtAttr Function SQLSetStmtOption Function SQLSpecialColumns Function SQLStatistics Function SQLTablePrivileges Function ...
sp_describe_cursor_tables [ @cursor_return = ] output_cursor_variable OUTPUT { [ , [ @cursor_source = ] N'local' , [@cursor_identity = ] N'local_cursor_name' ] | [ , [ @cursor_source = ] N'global' , [ @cursor_identity = ] N'global_cursor_name' ] | [ , [ @cursor_sour...
对于在比较和类似表达式中包含参数标记或包含限定谓词的 ODBC SQL 语句。 对于其参数之一为函数参数的任何查询。 当Transact-SQL 命令中有注释 (/* */) 时。 在对Transact-SQL 语句进行批处理时,对于批处理中第一个语句后的语句中的参数标记,该驱动程序也不支持调用SQLDescribeParam。
The name of the Transact-SQL server cursor defined.cursor_namemust conform to the rules for identifiers. INSENSITIVE Defines a cursor that makes a temporary copy of the data to be used by the cursor. All requests to the cursor are answered from this temporary table intempdb. Therefore, base...
SQL Server Client Tools Command Line Tools Windows 14669436 The bulk insert is blocked when the lock of the target table is held by another session, and the session of the bulk insert will remain in SQL Server until its lock is released even if the client application disconnects or exits. ...
SQL Server Engine High Availability and Disaster Recovery All 14910661 A memory leak occurs under "Range Index Heap" on the in-memory table that has non-clustered indexes, whenever there are concurrent inserts. SQL Server Engine In-Memory OLTP All 14923176 A memory leak occurs in the range inde...