Standard function examples in SQL

Only individual records are supported, but not for everyone to learn.

Use [crs_brand]

Go

 

/***** Object: userdefinedfunction [DBO]. [getfactorybyid] script Date: 05/19/2013 21:59:44 ******/

Set ansi_nulls on

Go

 

Set quoted_identifier on

Go

 

 

-- ===================================================== ======

-- Author: Peter Qiu

-- Create Date: 2013/05/15

-- Description: <get factory name>

-- ===================================================== ======

Create Function [DBO]. [getfactorybyid]

(

@ ID uniqueidentifier

)

Returns varchar (50)

As

Begin

Declare @ factoryname varchar (100)

 

Select @ factoryname = companyName from factorys where factoryid = @ ID

 

Return @ factoryname

End

Go