Microsoft® SQL Server® 2012 Bible

427 Chapter 16: Programming with T-SQL 16 Bulk Insert Options In practice, you probably need to use some options when using BULK ...

428 Part IV: Programming with T-SQL BULK INSERT handles columns in the order they appear in the source comma-delimited fi le, an ...

429 Chapter 16: Programming with T-SQL 16 ■ (^) IF controls only execution of the next line, unless it is followed by a BEGIN... ...

c16.indd 430c16.indd 430 7/30/2012 5:38:13 PM7/30/2012 5:38:13 PM http://www.it-ebooks.info ...

431 CHAPTER 17 Developing Stored Procedures IN THIS CHAPTER Creating and Managing Stored Procedures Passing Lists and Tables to ...

432 Part IV: Programming with T-SQL in SQL Server The Performance Myth Many DBAs and developers, especially those who worked wit ...

433 Chapter 17: Developing Stored Procedures 17 Create The CREATE statement must be the fi rst statement in a batch, and the ter ...

434 Part IV: Programming with T-SQL in SQL Server USE AdventureWorks2012 GO ALTER PROCEDURE Sales.uspGetCurrencyInformation AS S ...

435 Chapter 17: Developing Stored Procedures 17 .syscomments. Sp_helptext retrieves the stored procedure code and returns it as ...

436 Part IV: Programming with T-SQL in SQL Server USE AdventureWorks2012 GO ALTER PROCEDURE Sales.uspGetCurrencyInformation WITH ...

437 Chapter 17: Developing Stored Procedures 17 Alternatively, you can use the OpenQuery() function to call a remote stored proc ...

438 Part IV: Programming with T-SQL in SQL Server GO CREATE PROCEDURE Sales.uspGetCurrencyInformation @CurrencyCode char(3) AS S ...

439 Chapter 17: Developing Stored Procedures 17 the input parameter defi nition; simply place "= default value" after the input ...

440 Part IV: Programming with T-SQL in SQL Server If a list will be passed into the stored procedure using a string, you must us ...

441 Chapter 17: Developing Stored Procedures 17 The string value must be assigned to the input parameter as a single value, but ...

442 Part IV: Programming with T-SQL in SQL Server EXECUTE Sales.uspGetCurrencyInformationXML @XMLList =' <ROOT> <Curren ...

443 Chapter 17: Developing Stored Procedures 17 EXECUTE sp_xml_removedocument @XMLDocHandle; GO --Execute the stored procedure E ...

444 Part IV: Programming with T-SQL in SQL Server WHERE CurrencyRateDate = @CurrencyRateDate; GO To execute the stored procedure ...

445 Chapter 17: Developing Stored Procedures 17 Best Practice With every operation that affects data, SQL Server, by default, al ...

446 Part IV: Programming with T-SQL in SQL Server The stored procedure completes and execution is passed back to SSMS. The valu ...