第四讲 自定义函数及存储过程.pdfVIP

2 Select Len(ABC) 3 Select CharIndex(B,ABC) 2 Select CharIndex(BD,ABCD) 0 Select CharIndex(B,ABCDBC,3) 5 Select SubString(ABC,2,1) B Select SubString(ABC,2,3) BC Select CharIndex(SubString(ABC,2,1),BCD) 1 4.1 2: Scalar function RowSet table 2 • “ ” • “ ” —— Scalar function text ntextimagecursor rowversion(timestamp) CREATE FUNCTION [ owner_name.] function_name ( [ { @parameter_name [AS] scalar_parameter_data_type [ = default ] } [ ,...n ] ] ) RETURNS scalar_return_data_type [ WITH function_option [ [,] ...n] ] [ AS ] BEGIN function_body RETURN scalar_expression END function_