Get_property_value

SQL

function Get_property_value(IN owner CHAR(32), IN name CHAR(36), IN num INT); RETURNS CHAR(254);


Parametry

owner
property owner
name
property name
num
property value number


Od verze

8.0

Popis

This function reads the value of the name property of the specified owner. If the property has more than one value (e.g. Dir1, Dir2), the num value specifies the parameter, otherwise num must equal 0.

The function called in SQL returns the property value as its return value. The property value is returned as a character string.

The name and owner parameters are not case-sensitive.

A SQL server properties owner is designated by the "@SQLSERVER" string.



Návratová hodnota

Returns the property value in SQL.

Viz