第四讲 自定义函数及存储过程.pdf
文本预览下载声明
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_
显示全部