python ruby-programming-language Smalltalk Vue.js Knockoutjs TypeScript JavaScript, OOPs JavaScript Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 4 Angular 2 AngularJs 1.x NodeJs Perl Programming R Programming RequireJs Rust Programming Backbonejs closure programming language go-programming-language kotlin-programming-language
sql server create functions example

SQL Server create functions example

Hello everyone,  I am going to share the code sample for create sql functions

Table of Contents
  1. Add returns type like varchar, int etc.
  2. Declare the return variable.
  3. Add the T-sql statements to compute the return value.
  4. Return the result of the function.

The example for the same as given below.

CREATE FUNCTION [dbo].[fun_GetOrderType]
(
            @Return SMALLINT,
            @Reprocess SMALLINT,
            @Cancel SMALLINT
)
RETURNS VARCHAR(10)
AS
BEGIN
            -- DECLARE THE RETURN VARIABLE HERE.
            DECLARE @type VARCHAR(10)='XYZ'

            -- ADD THE T-SQL STATEMENTS TO COMPUTE THE RETURN VALUE HERE.
            IF (@Return = 1)
                        SET @type = 'RE'
            ELSE IF (@Reprocess = 2)
                        SET @type = 'RPC'
            ELSE IF (@Cancel = 3)
                        SET @type = 'CNL'

            -- RETURN THE RESULT OF THE FUNCTION
            RETURN @type
END



ANIL SINGH

Hi there! Welcome to my blog. My name is Anil Singh. I'm a author of this blog. For more detail about me, kindly refer to this link..
My Blogs - http://code-sample.com and http://code-sample.xyz
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like
www.code-sample.com/. Powered by Blogger.
ASK Questions