Browse by Tags

All Tags » SmartObject » BlackPearl » SQL Server   (RSS)
Sorry, but there are no more tags available to filter with.
  • Re: Using SQL Server Views instead of tables

    Hi Alex, I've not attempted this with SQL Views, but you could try: SELECT * INTO YourNewTableName FROM YourExistingViewName as this will create a table from your view. If you want, you can get SQL Server Agent to run a job to recreate this table every hour or something with a TSQL statement like:   use ...
    Posted to General (Forum) by mgallen on February 19, 2008