SQL函数

SQL函数
CREATE FUNCTION [dbo].[函数名] (@生产日期 DATETIME, @范围口径 VARCHAR(100))
RETURNS @Table TABLE (SYMBOL VARCHAR(20), EXCHANGE VARCHAR(20))
AS
BEGIN
IF @范围口径 = ‘口径1’
BEGIN

INSERT @Table
SELECT
	A.SYMBOL, A.EXCHANGE
FROM
(SELECT CompanyCode, SYMBOL, EXCHANGE FROM CODE A WHERE PUBLISHDATE = CONVERT(VARCHAR(8), @生产日期, 112)) A;

RETURN;

END;
INSERT @Table SELECT CAST(‘参数有误’ AS INT), ‘’;
RETURN;
END;