Results 1 to 6 of 6

Thread: SQL Views with Computed Columns

Threaded View

  1. Jan 25th, 2009, 04:41 AM #1
    jsc0624
    jsc0624 is offline

    Thread Starter
    Addicted Member
    Join Date
    Mar 2007
    Posts
    240

    SQL Views with Computed Columns

    Hi Guys,

    Is it possible for me to create views with persisted column?

    Code:
    CREATE VIEW dbo.viewTable AS
SELECT
   Item1,
   Item2,
   Total AS (Item1+Item2) PERSISTED
FROM
   Table1 t1
JOIN
   Table2 t2
ON
   t1.ID = t2.ID
    Also what is the proper syntax for this?
    Last edited by jsc0624; Jan 25th, 2009 at 04:45 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width