sql server 创建函数

资料

-- SELECT *from  wzh_demo1CREATE FUNCTION mydemo1(@aaa varchar（20）)RETURNS @table table(id int ,book VARCHAR(20),descript VARCHAR(20),money_ VARCHAR(20), author VARCHAR(20))asBEGIN    INSERT into @table(id,book,descript,money_,author)    SELECT * from wzh_demo1 where book=@aaa    return end

 

运行函数效果