sql server 2008 views

Question

How to call the two views I have a two parameterised views first call one view after call the second view with first view result please give me examples

Jignesh Trivedi · Answer

hi SQL View behave like virtual table that contain the query. this can be also achieve by using User define function or stored procedure. Please refer http://msdn.microsoft.com/en-us/library/c11kd98s(v=vs.80).aspx hope this will help you.

Jaganathan Bantheswaran · Answer

Hi You can't create parameterized views in sql server 2008. You have to use SP instead of Views.