大家好!请问如何将以下的结果放在一个视图中,或者我把自定义函数改为存储过程,请问视图可以调用存储过程吗?请各位指教!DECLARE perdatCursor CURSOR FOR
SELECT bkjrcode,bgdatum,eddatum
FROM perdat OPEN perdatCursordeclare @FinYear int
declare @Fromdate datetime
declare @Todate datetime fetch next from perdatcursor into @FinYear,@Fromdate,@Todate
while(@@fetch_status=0) begin select * from dbo.test_func(@FinYear,@Fromdate,@Todate) fetch next from perdatcursor into @FinYear,@Fromdate,@Todate end close perdatcursordeallocate perdatcursor
SELECT bkjrcode,bgdatum,eddatum
FROM perdat OPEN perdatCursordeclare @FinYear int
declare @Fromdate datetime
declare @Todate datetime fetch next from perdatcursor into @FinYear,@Fromdate,@Todate
while(@@fetch_status=0) begin select * from dbo.test_func(@FinYear,@Fromdate,@Todate) fetch next from perdatcursor into @FinYear,@Fromdate,@Todate end close perdatcursordeallocate perdatcursor
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货