=50 RAISERROR('Row count does not equal 50',16,1) ROLLBACK TRANSACTION TestTransaction 备注 在执行 COMMIT TRANSACTION 语句后不能回滚事务。 有关ROLLBACK TRANSACTION 如何与存储过程和触发器一起使用的详细信息,请参见 Microsoft 网站上的网页:ROLLBACK TRANSACTION (Transact-SQL)。
When defining INSTEAD OF TRIGGERS for LOB columns, you can read both the :OLD and the :NEW value, but you cannot write either the :OLD or the :NEW values. Note: You can create multiple triggers of the same type (BEFORE, AFTER, or INSTEAD OF) that fire for the same statement on...
return FALSE; // Execute the statement. retcode = SQLExecute(hstmt); if ( retcode == SQL_ERROR ) return FALSE; if ( retcode == SQL_NEED_DATA ) { // Use SQLParamData to loop through DAE input parameters. For // each, use SQLPutData to send the data t...
When you create or modify a database, you can use the COLLATE clause of the CREATE DATABASE or ALTER DATABASE statement to specify the default database collation. If no collation is specified, the database is assigned the server collation....
You create user-defined types with the CREATE TYPE statement before they can be used in a table definition. The following are criteria for type_name of an altered column: The previous data type must be implicitly convertible to the new data type. type_name can't be timestamp. ANSI_NULL ...
BOOLEAN_STATEMENT_WITH_EMPTY_ROW、 ROW_SUBQUERY_TOO_MANY_ROWS、 SCALAR_SUBQUERY_TOO_MANY_ROWS 21506 數據表的相同數據列不能是多個更新、刪除或插入作業的目標。 DELTA_MULTIPLE_SOURCE_ROW_MATCHING_TARGET_ROW_IN_MERGE 21S01 插入值清單不符合資料列清單 COPY_INTO_COLUMN_ARITY_MISMATCH、CREATE_VIEW_COLUMN...
pred_compare sqlserver equal_i_sql_ansi_string 兩個SQL ANSI 字串值之間的等號比較運算子 pred_source sqlos task_execution_time 取得目前工作的執行時間 pred_source sqlserver client_app_name 取得目前用戶端應用程式名稱 目標 package0 etw_classic_sync_target Windows 事件追蹤 (ETW) 同步目標 目標 package...
avoid insertion of duplicate entries in a BULK INSERT statement Bad performance of EXCEPT operator Basic - select with fixed values - invert columns to rows Basic CTE query, get full path of something recursive BCP Error - Copy direction must be either 'in', 'out' or 'format'. BCP Export...
SQLSTATE values are designed so that application programs can test for specific errors or classes of errors. The first character of an SQLSTATE value indicates whether the SQL statement was executed successfully or unsuccessfully (equal to or not equal to zero, respectively). SQLSTATE values are ...
The following statement creates a rollback segment with default storage values in the system tablespace: CREATE ROLLBACK SEGMENT rbs_2 TABLESPACE system; The above statement is equivalent to the following: CREATE ROLLBACK SEGMENT rbs_2 TABLESPACE system STORAGE ( INITIAL 10K NEXT 10K MAXEXTENTS ...