sql創(chuàng)建一個(gè)自定義函數(shù) SQL Server中，自定義函數(shù)有哪三種？
SQL Server中，自定義函數(shù)有哪三種？CREATE FUNCTION FUNu COMPUTE（@NUM INT）返回FLOAT--FLOAT BEGIN DECLARE@NUMu CURREN
SQL Server中，自定義函數(shù)有哪三種？
CREATE FUNCTION FUNu COMPUTE（@NUM INT）返回FLOAT--FLOAT BEGIN DECLARE@NUMu CURRENT INT--數(shù)SET@NUMu CURRENT=1DECLARE@RESULT FLOATSET@RESULT=0 DECLARE@SIGN VARCHAR（1）SET@SIGN=“”WHILE@NUMu CURRENT<=@numberginif@符號(hào)=“”BEGINSET@RESULT=@結(jié)果@NUMu CURRENTSET@符號(hào)=“-”ENDELSEBEGINSET@結(jié)果=@RESULT-@NUMu CURRENTSET@符號(hào)=“”結(jié)束集@NUMu CURRENT=@NUMu CURRENT2END RETURN@RESULTEND—選擇DBO.FUNu計(jì)算(7)