Microsoft® SQL Server® 2012 Bible

447 Chapter 17: Developing Stored Procedures 17 The following example alters the stored procedure created to illustrate output p ...

448 Part IV: Programming with T-SQL in SQL Server @CurrencyName = @CurrencyNameOutput OUTPUT; PRINT @CurrencyNameOutput; PRINT @ ...

449 Chapter 17: Developing Stored Procedures 17 FROM Sales.Currency WHERE CurrencyCode = @CurrencyCode; --Detail Information SEL ...

450 Part IV: Programming with T-SQL in SQL Server ); GO --Create Procedure CREATE PROCEDURE Sales.uspInsertNewCurrency @Currency ...

451 Chapter 17: Developing Stored Procedures 17 FIGURE 17-1 Possible ways for stored procedures to pass data. Client App Result ...

c17.indd 452c17.indd 452 7/30/2012 5:39:37 PM7/30/2012 5:39:37 PM http://www.it-ebooks.info ...

453 CHAPTER 18 Building User-Defi ned Functions IN THIS CHAPTER Creating Scalar Functions Replacing Views with Inline Table-valu ...

454 Part IV: Programming with T-SQL User-defi ned functions come in three distinct types (as shown in Figure 18-1). Management S ...

455 Chapter 18: Building User-Defi ned Functions 18 If you’d like to see the metadata associated with UDFs in your database, the ...

456 Part IV: Programming with T-SQL Creating a Scalar Function User-defi ned functions are created, altered, or dropped with the ...

457 Chapter 18: Building User-Defi ned Functions 18 GO CREATE FUNCTION dbo.ufnGetOrderTotalByProduct(@ProductID int) RETURNS int ...

458 Part IV: Programming with T-SQL Inline Table-Valued Functions The second type of user-defi ned function, the inline table-va ...

459 Chapter 18: Building User-Defi ned Functions 18 Result (abridged): ProductID Name TotalOrders ----------- ------------------ ...

460 Part IV: Programming with T-SQL SQL Server internally creates a new SQL statement from dbo.vwProductOrderTotals and the call ...

461 Chapter 18: Building User-Defi ned Functions 18 CROSS APPLY dbo.ufnProductOrderTotals(p.ProductID) t ORDER BY t.TotalOrders ...

462 Part IV: Programming with T-SQL To create a function with schema binding, add the option after RETURNS and before AS during ...

463 Chapter 18: Building User-Defi ned Functions 18 The following process builds a multistatement table-valued, user-defi ned fu ...

464 Part IV: Programming with T-SQL Result: ProductID ProductName TotalOrders ----------- ----------------------------- -------- ...

465 Chapter 18: Building User-Defi ned Functions 18 Using Consistent Naming Conventions There are few things more frustrating th ...

c18.indd 466c18.indd 466 7/30/2012 5:41:48 PM7/30/2012 5:41:48 PM http://www.it-ebooks.info ...