create Function fx_disp_Accdet(@accnum int)
Returns Table with Schemabinding
as
Return
(
select Customer_name, Acc_num
from dbo.Depositor
Where Acc_num=@accNum
)
select * from Fx_Disp_AccDet(101)
Returns Table with Schemabinding
as
Return
(
select Customer_name, Acc_num
from dbo.Depositor
Where Acc_num=@accNum
)
select * from Fx_Disp_AccDet(101)
No comments:
Post a Comment