create function fn_view1.sql

来自「在学习SQL Server过程中整理的T-SQL语句」· SQL 代码 · 共 13 行

use test
go
create function fn_view1
(@para nvarchar(30))
returns table
as return
(
select sno,sname
       from XS
       where department=@para
)
go