Microsoft® SQL Server® 2012 Bible

407 Chapter 16: Programming with T-SQL 16 Global Temporary Tables Global temporary tables are similar to local temporary tables ...

408 Part IV: Programming with T-SQL Table variables are declared as variables, rather than created with SQL DDL statements. When ...

409 Chapter 16: Programming with T-SQL 16 What’s New in T-SQL for 2012 New features and enhancements in SQL Server 2012 are high ...

410 Part IV: Programming with T-SQL WHERE c.ProductCategoryID = @ProductCategoryID', N'@ProductCategoryID int', 0); Sys.dm_exec_ ...

411 Chapter 16: Programming with T-SQL 16 USE AdventureWorks2012; GO SELECT DepartmentID, Name FROM HumanResources.Department OR ...

412 Part IV: Programming with T-SQL DepartmentID Name ------------ -------------------------- 5 Purchasing 6 Research and Develo ...

413 Chapter 16: Programming with T-SQL 16 The basic error information system functions, such as @@error and @@rowcount, contain ...

414 Part IV: Programming with T-SQL operation failed, which might indicate a data, logic, or business rule problem. The @@rowCou ...

415 Chapter 16: Programming with T-SQL 16 Error Severity Windows has established standard error-severity codes, listed in Table ...

416 Part IV: Programming with T-SQL The sys.messages table includes columns for the message_id, text, severity, and whether the ...

417 Chapter 16: Programming with T-SQL 16 Logging the Error Another advantage to using the RAISERROR command is that it can log ...

418 Part IV: Programming with T-SQL SQL Server Log SQL Server also maintains a series of log fi les. Each time SQL Server starts ...

419 Chapter 16: Programming with T-SQL 16 BEGIN TRY <SQL code>; END TRY BEGIN CATCH <error handling code>; END CATCH ...

420 Part IV: Programming with T-SQL If the batch uses logical transactions (BEGIN TRAN/COMMIT TRAN), then, depend- ing on the e ...

421 Chapter 16: Programming with T-SQL 16 The following sample demonstrates a CATCH block using the CATCH functions and a RAISER ...

422 Part IV: Programming with T-SQL END TRY BEGIN CATCH THROW; END CATCH; Result: Msg 8134, Level 16, State 1, Line 3 Divide by ...

423 Chapter 16: Programming with T-SQL 16 TABLE 16 - 4 Differences between RAISERROR and THROW RAISERROR THROW A msg_id passed t ...

424 Part IV: Programming with T-SQL AS BEGIN TRY SELECT 3/0 END TRY BEGIN CATCH THROW 50002,'CalledProc Raiserror',1 END CATCH G ...

425 Chapter 16: Programming with T-SQL 16 data need to get into SQL Server in a limited time frame, a bulk operation is the way ...

426 Part IV: Programming with T-SQL To test the BULK INSERT command, use the Address.csv fi le that’s part of the build script t ...