This prefix is used by SQL Server to designate system procedures. Using the prefix can cause application code to break if there is a system procedure with the same name.Local or global temporary procedures can be created by using one number sign (#) before procedure_name (#procedure_name) ...
mask_function 是遮罩函式的名稱並具備適當的參數。 可用的函式有四個: default() email() partial() random() 需要ALTER ANY MASK 權限。 如需函式參數,請參閱動態資料遮罩。 FILESTREAM 適用於:SQL Server 2008 R2 (10.50.x) 和更新版本。 僅適用於 varbinary(max) 資料行。 指定 FILESTREAM 儲存體來...
This prefix is used by SQL Server to designate system procedures. Using the prefix can cause application code to break if there is a system procedure with the same name.Local or global temporary procedures can be created by using one number sign (#) before procedure_name (#procedure_name...
mask_function 是遮罩函式的名稱並具備適當的參數。 可用的函式有四個: default() email() partial() random() 需要ALTER ANY MASK 權限。 如需函式參數,請參閱動態資料遮罩。 FILESTREAM 適用於:SQL Server 2008 R2 (10.50.x) 和更新版本。 僅適用於 varbinary(max) 資料行。 指定 FILESTREAM 儲存體來...
Temporary tables Show 12 more Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance SQL database in Microsoft Fabric Creates a new table in the database. Note For reference to Warehouse in Microsoft Fabric, visit CREATE TABLE (Fabric Data Warehouse). For reference to Azure Syn...
mask_function 是具有相应参数的掩码函数的名称。 有四个函数可供选择: default() email() partial() random() 需要ALTER ANY MASK 权限。 有关函数参数的信息,请参阅动态数据掩码。 FILESTREAM 适用于:SQL Server 2008 R2 (10.50.x) 及更高版本。 仅对varbinary(max) 列有效。 请为 varbinary(max) BLOB ...
Temporary tables Show 12 more Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance SQL database in Microsoft Fabric Creates a new table in the database. Note For reference to Warehouse in Microsoft Fabric, visit CREATE TABLE (Fabric Data Warehouse). For reference to Azure Syn...
Temporary tables Show 12 more Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance SQL database in Microsoft Fabric Creates a new table in the database. Note For reference to Warehouse in Microsoft Fabric, visit CREATE TABLE (Fabric Data Warehouse). For reference to Azure Syn...
SQL 型 V3.1.5 开发者指南 SQL 参考 SQL语句 CREATE TABLE 更新时间:2025-03-07 23:00:00 编辑 描述 该语句用来在数据库中创建一张新表。 格式 CREATE[TEMPORARY]TABLE[IFNOTEXISTS]table_nameLIKEtable_name;table_definition_list: table_definition[,table_definition...]table_definition: column_definition...
temporary table tmp(id int); ERROR 1787 (HY000): Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executedoutside transactionalcontext. These statements are also not allowed in a function or trigger because functions and triggers are also considered ...