Thursday, April 26, 2007

User Parameter in View

create function dbo.MyFunc (@parm int)
returns table
as
return (
select col1, col2
from dbo.MyTable
where idcol > @parm
)

select col1, col2 from dbo.MyFunc(5)




http://www.thescripts.com/forum/thread79868.html



http://www.thescripts.com/for
um/thread79868.html

0 comments: