[SQL Server] 存储过程事务
在存储过程中使用事务，以下为模板：
CREATE PROCEDURE testPro
AS
/**//* ------- 事务开始---------- */
BEGIN TRANSACTION tran_test
/**//* -------- 保存事务----------*/
SAVE TRANSACTION tran_test
/**//* -------- 数据操作---------*/
INSERT [table1] ( [content] ) VALUES ( '43332' )
/**//*---------- 提交事务------------*/
COMMIT TRANSACTION tran_test
/**//*--------- 判断是否有错误----------*/
IF ( @@ERROR <> 0 )
BEGIN
/**//*---------- 自定义错误输出----------*/
RAISERROR( 'Insert data error!',16,1 )
/**//*-------- 事务回滚--------*/
ROLLBACK TRANSACTION tran_test
END
/**//*------- 判断事务数是否大于-----------*/
IF ( @@TRANCOUNT > 0 )
BEGIN
/**//*-------- 事务回滚--------*/
ROLLBACK TRANSACTION tran_test
END
GO
相关文档：
1.
select top m * from tablename where id not in (select top n id from tablename)
2.
select top & ......
格式:
CONVERT(data_type,expression[,style])
说明:
此样式一般在时间类型(datetime,smalldatetime)与字符串类型(nchar,nvarchar,char,varchar)
相互转换的时候才用到.
例子:
SELECT CONVERT(varchar(30),getdate(),101) now
结果为:
now
---------------------------------------
|09/15/2001
===== ......
The aspnet_Profile table contains the following fields: UserId, PropertyNames, PropertyValuesString, PropertyValuesBinary, and LastUpdatedDate. The PropertyNames field contains a string delimited with colons (:) that identify which profile fields are stored, what their datatype is and their of ......
1．SQL并行查询
alter session enable parallel dml execute immediate 'alter session enable parallel dml'; --修改会话并行DML select /*+parallel(a,4)*/ * from table_name a select /*+parallel(a,8)*/ * from table_name a ......
