评论

#fghshy 发表于2007-11-10 13:22:05  IP: 222.209.208.*

use NOrthWind
go
Alter Function Test
(
@str char(1)
)
returns @Tp table(EmployeeID int,EmployeeName nvarchar(30))
as
begin
declare @Tmp table(EmployeeID int,EmployeeName nvarchar(30))
if @str='S'
begin
insert into @Tmp
select EmployeeID ,lastName as 'Employee Name'
from Employees

end
else if @str='L'
begin
insert into @Tmp
select EmployeeID,FirstName+' '+LastName as 'Employee Name'
from Employees
end

insert into @Tp
select * from @Tmp
return

end

--test-----

select *
from Test('S')

select *
from Test('L')
--test-----

#fghshy 发表于2007-11-10 13:23:35  IP: 222.209.208.*

不知哪位高手还有更简便的写发没有

#ZZJ_4Ever 发表于2007-11-12 20:27:33  IP: 218.88.65.*

暂时还没有！