Satishbabu_dasari
Newbie
Points: 1
More actions
October 23, 2001 at 8:05 am
#77873
Can we write materialized views in the MS SQL Server 6.5? If yes please give the syntax. If no, please tell me, is there any alternate way?
Andy Warren
SSC Guru
Points: 119902
October 24, 2001 at 6:24 am
#419244
Not simply. You would have to write the triggers to maintain the view (table).
Andy
AndySQLAndy - My Blog!Connect with me on LinkedInFollow me on Twitter
Steve Jones - SSC Editor
Points: 735513
October 24, 2001 at 10:19 am
#419263
You would have to do as Andy said and duplicate data in a separate table.
You can index views (very similar) in SQL 2000.
Steve Jones
steve@dkranch.net
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply