view problem

• hpyazici

  Newbie

  Points: 2

  More actions

  October 1, 2003 at 1:30 am

  #84453

  Hi,

  if exists (select * from sysobjects where type = 'V' and name = 'SerialControlView')

  Begin

  ALTER VIEW dbo.SerialControlView AS

  SELECT UserId, Choice AS Secim, PdfId FROM dbo.SerialControl WHERE RIGHT(PdfId, LEN('MEMO??!!.pdf'))= 'MEMO0304.pdf'

  End

  Else

  Begin

  CREATE VIEW dbo.SerialControlView AS

  SELECT UserId, Choice AS Secim, PdfId FROM dbo.SerialControl WHERE RIGHT(PdfId, LEN('MEMO??!!.pdf'))= 'MEMO0304.pdf'

  End

  --------------------------------

  Server: Msg 156, Level 15, State 1, Line 3

  Incorrect syntax near the keyword 'VIEW'.

  Server: Msg 156, Level 15, State 1, Line 8

  Incorrect syntax near the keyword 'VIEW'.

  what is the problem?

• Ian Scarlett

  SSC-Insane

  Points: 23197

  More actions

  October 1, 2003 at 2:16 am

  #476497

  ALTER VIEW, CREATE VIEW and a whole host of other statements must be the only statements in a batch. Try this instead:-

  if exists (select * from sysobjects where type = 'V' and name = 'SerialControlView')

  drop view SerialControlView

  go

  CREATE VIEW dbo.SerialControlView AS

  SELECT UserId, Choice AS Secim, PdfId FROM dbo.SerialControl WHERE RIGHT(PdfId, LEN('MEMO??!!.pdf'))= 'MEMO0304.pdf'

  go

• hpyazici

  Newbie

  Points: 2

  More actions

  October 1, 2003 at 6:14 am

  #476532

  very thanks ianscarlett.