Beginning C# 2008 Databases 笔记(三)
CHAPTER 8 Understanding Transactions
了解事务
你能使用除了一下这些的 T-SQL statements 在一个事务中:
ALTER DATABASE, RECONFIGURE, BACKUP, RESTORE, CREATE DATABASE, UPDATE STATISTICS, and
DROP DATABASE.
Also, you cannot use sp_dboption to set database options or use any system procedures
that modify the master database inside explicit or implicit transactions.
• BEGIN TRANSACTION: 开始
• COMMIT TRANSACTION: 成功
• ROLLBACK TRANSACTION: 失败
@@ERROR 返回错误编号,成功返回 0。
Code
ado.net
CHAPTER 9 Getting to Know ADO.NET
![](/images/cnblogs_com/dz2345/a.jpg)
SqlTypes Maps SQL Server data types to .NET types
CHAPTER 10 Making Connections
data source = .\sqlexpress
server = .\sqlexpress
address = .\sqlexpress
addr = .\sqlexpress
network address = .\sqlexpress
了解事务
你能使用除了一下这些的 T-SQL statements 在一个事务中:
ALTER DATABASE, RECONFIGURE, BACKUP, RESTORE, CREATE DATABASE, UPDATE STATISTICS, and
DROP DATABASE.
Also, you cannot use sp_dboption to set database options or use any system procedures
that modify the master database inside explicit or implicit transactions.
• BEGIN TRANSACTION: 开始
• COMMIT TRANSACTION: 成功
• ROLLBACK TRANSACTION: 失败
@@ERROR 返回错误编号,成功返回 0。
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
CHAPTER 9 Getting to Know ADO.NET
![](/images/cnblogs_com/dz2345/a.jpg)
SqlTypes Maps SQL Server data types to .NET types
CHAPTER 10 Making Connections
data source = .\sqlexpress
server = .\sqlexpress
address = .\sqlexpress
addr = .\sqlexpress
network address = .\sqlexpress