none
Create Dynamic View SQL server RRS feed

Answers

All replies

  • Using the data provider SqlClient in combination with the following

    http://www.sqlteam.com/article/introduction-to-dynamic-sql-part-2


    Please remember to mark the replies as answers if they help and unmark them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.
    VB Forums - moderator
    profile for Karen Payne on Stack Exchange, a network of free, community-driven Q&A sites

    Friday, October 20, 2017 11:16 AM
    Moderator
  • Thanks.

    I am looking for dynamically create view in my backend (WebApp using .net C#). Need to give the admin a right to select which columns should show in special view (Public view).

    I thought it's a good idea to deal with dynamic view. Every time the admin change or add new column I drop the view or alter the view with new.

    Friday, October 20, 2017 11:48 AM