摘要：
这一篇很简单,看代码:USE DorbenGOBEGIN TRY -- Generate a divide-by-zero error. SELECT 1/0;END TRYBEGIN CATCH SELECT ERROR_NUMBER() AS ErrorNumber, ERROR_SEVERITY() AS ErrorSeverity, ERROR_STATE() AS ErrorState, ERROR_PROCEDURE() AS ErrorProcedure, ... 阅读全文
摘要：
这次的测试数据稍有复杂,先看下SQL脚本:CREATE TABLE Person( ID INT IDENTITY(1,1) NOT NULL, Name NVARCHAR(20) NOT NULL DEFAULT(''), Age INT DEFAULT(0) NOT NULL, Sex BIT DEFAULT(0) NOT NULL)--DROP TABLE [Order]CREATE TABLE [Order]( ID INT IDENTITY(1,1) PRIMARY KEY, PersonID INT DEFAULT(0) NOT NULL, ... 阅读全文