dbo.ufnLeadingZeros User Defined Function

Description

Scalar function used by the Sales.Customer table to help set the account number.

Properties

Creation Date	08/01/2010 08:40
Encrypted
Ansi Nulls

Parameters

Parameter	Direction	Description	Data Type	Size
@Value	In	Input parameter for the scalar function ufnLeadingZeros. Enter a valid integer.	int	4
@RETURN_VALUE	Return Value		varchar	8

Objects that depend on dbo.ufnLeadingZeros

Database Object	Object Type	Description	Dep Level
Sales.Customer	Table	Current customer information. Also see the Individual and Store tables.	1
Sales.CustomerAddress	Table	Cross-reference table mapping customers to their address(es).	2
iduSalesOrderDetail	Trigger	AFTER INSERT, DELETE, UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in SalesOrderDetail and updates the SalesOrderHeader.SubTotal column.	4
Sales.Individual	Table	Demographic data about customers that purchase Adventure Works products online.	2
iStore	Trigger	AFTER INSERT trigger inserting Store only if the Customer does not exist in the Individual table.	3
iuIndividual	Trigger	AFTER INSERT, UPDATE trigger inserting Individual only if the Customer does not exist in the Store table and setting the ModifiedDate column in the Individual table to the current date.	3
Sales.SalesOrderDetail	Table	Individual products associated with a specific sales order. See SalesOrderHeader.	3
Sales.SalesOrderHeader	Table	General sales order information.	2
Sales.SalesOrderHeaderSalesReason	Table	Cross-reference table mapping sales orders to sales reason codes.	3
Sales.Store	Table	Customers (resellers) of Adventure Works products.	2
Sales.StoreContact	Table	Cross-reference table mapping stores and their employees.	3
uSalesOrderHeader	Trigger	AFTER UPDATE trigger that updates the RevisionNumber and ModifiedDate columns in the SalesOrderHeader table.Updates the SalesYTD column in the SalesPerson and SalesTerritory tables.	3
Sales.vIndividualCustomer	View	Individual customers (names and addresses) that purchase Adventure Works Cycles products online.	2
Sales.vIndividualDemographics	View	Displays the content from each element in the xml column Demographics for each customer in the Sales.Individual table.	3
Sales.vSalesPersonSalesByFiscalYears	View	Uses PIVOT to return aggregated sales information for each sales representative.	3
Sales.vStoreWithDemographics	View	Stores (names and addresses) that sell Adventure Works Cycles products to consumers.	2

Procedure Source Code

CREATE FUNCTION [dbo].[ufnLeadingZeros](
@Value int
) 
RETURNS varchar(8) 
WITH SCHEMABINDING 
AS 

BEGIN
DECLARE @ReturnValue varchar(8);
SET @ReturnValue = CONVERT(varchar(8), @Value);
SET @ReturnValue = REPLICATE('0', 8 - DATALENGTH(@ReturnValue)) + @ReturnValue;
RETURN (@ReturnValue);
END;

Related Objects

dbo Schema
AdventureWorks Database