2012 m. spalio 17 d., trečiadienis

Add column to VIEW in MS SQL steps

  1. CREATE
    VIEW [dbo].[APP_TEST] AS select a.id, a.Criterion  from Criterions as a
  2. ALTER
    VIEW [dbo].[APP_TEST] AS select a.id, a.Criterion, a.Explain from Criterions as a
  3. SELECT
    * FROM APP_TEST

Komentarų nėra:

Rašyti komentarą