sql創(chuàng)建一個(gè)自定義函數(shù) SQLserver創(chuàng)建一個(gè)函數(shù)?
SQLserver創(chuàng)建一個(gè)函數(shù)?CREATE FUNCTION fun_getscore ( @name varchar(20), --源字串 @courseid int --分隔符 ) RETURN
SQLserver創(chuàng)建一個(gè)函數(shù)?
CREATE FUNCTION fun_getscore ( @name varchar(20), --源字串 @courseid int --分隔符 ) RETURNS table AS RETURN ( select score from 表名 where stuname=@name and courseID=@courseid) 下面是函數(shù)調(diào)用 select from dbo.fun_getscore("10001",68)