Table of Contents

Class TMssqlCreateFunction

Namespace
gudusoft.gsqlparser.stmt.mssql
Assembly
gudusoft.gsqlparser.dll
public class TMssqlCreateFunction : TStoredProcedureSqlStatement, Visitable
Inheritance
TMssqlCreateFunction
Implements
Inherited Members

Constructors

TMssqlCreateFunction(EDbVendor) 

public TMssqlCreateFunction(EDbVendor dbvendor)

Parameters

dbvendor EDbVendor

Properties

Block 

public virtual TMssqlBlock Block { get; set; }

Property Value

TMssqlBlock

statements in create function

FunctionName

The name that you give to the function that you are declaring or defining. @return

public virtual TObjectName FunctionName { get; set; }

Property Value

TObjectName

FunctionType 

public virtual int FunctionType { get; set; }

Property Value

int

ProcedureOptions 

public virtual List<TProcedureOption> ProcedureOptions { get; set; }

Property Value

List<TProcedureOption>

ReturnDataType 

public virtual TTypeName ReturnDataType { get; set; }

Property Value

TTypeName

ReturnMode

create function of sql server may return normal datatype, or return TABLE, or TABLE with variable

TBaseType.function_return_datatype

TBaseType.function_return_table

TBaseType.function_return_table_variable

if return mode is TBaseType.function_return_datatype, check datatype in returnDataType

if return mode is TBaseType.function_return_table_variable, check returnTableVaraible and tableDefinitions. @return 

public virtual int ReturnMode { get; set; }

Property Value

int

ReturnStmt 

public virtual TMssqlReturn ReturnStmt { get; set; }

Property Value

TMssqlReturn

this is the only return statement in create function.

ReturnTableDefinitions 

public virtual TTableElementList ReturnTableDefinitions { get; set; }

Property Value

TTableElementList

ReturnTableVaraible 

public virtual TObjectName ReturnTableVaraible { get; set; }

Property Value

TObjectName

StoredProcedureName 

public override TObjectName StoredProcedureName { get; }

Property Value

TObjectName

Methods

accept(TParseTreeVisitor) 

public override void accept(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

acceptChildren(TParseTreeVisitor) 

public override void acceptChildren(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

doParseStatement(TCustomSqlStatement)

analyze SQL

public override int doParseStatement(TCustomSqlStatement psql)

Parameters

psql TCustomSqlStatement

Returns

int
Edit this page