Views

[VBXL]

Is it possible to pass a variable into a View

if so, how do you do it.

Cheers

GazC

 

[rajeevnandanmishra]

Hi GazC,
Views are created to show only the required information to the users and you can use view just like tables (i.e. select/ insert/ update/ delete).

 

[tlbroadbent]

No, you cannot pass a variable to a view. Views do not execute code. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

 

[vechalapu]

Hi,

You can have a view on combination of tables but cannot insert, update or delete if a view is created on multiple tables.

 

[tlbroadbent]

Updatable views can modify more than one table involved in the view. The DELETE, INSERT, and UPDATE statements can reference a view as long as SQL Server can translate the user's update request unambiguously to updates in the base tables referenced in the view's definition. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

 

[jjonesal]

Not sure what you're trying to do, but perhaps you could create a stored procedure that accepts an input parameter and use this parameter inside the procedure w/ dynamic sql statement (sp_executesql) to return the appropriate result set.

Hope this helps...

JJ