Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Vishal_sql
Posting Yak Master
102 Posts |
Posted - 2013-05-13 : 07:39:20
|
Hi AllI want to create viewwith parameters.So I have created parameterised function which accepts 3 input parameters.function name:- checkimportexceldata('projectname',revnum,'2013-04-20') I want to create view using the above parameterized functionWhats way to create parameteriozed view as using of parameterized function in View is also not allowedAny suggestion would be helpful |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-13 : 07:45:13
|
There's nothing called parameterised views in t-sql. You should be using table valued functions or procedures instead if you want to parameterize.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|