[thelist] (sql2k) syntax error in sproc

Tab Alleman Tab.Alleman at MetroGuide.com
Wed Jul 9 09:41:15 CDT 2003


Stevenson Ngila wrote:

> Try
> <><>><><><<><>><><><<><>><><><<><>><><><<><>><><><
> IF EXISTS Begin
>  SELECT * FROM sysobjects
> 	   WHERE id = object_id(N'[dw_tab].[dbo].[@ArchiveTableName]')
> 	   AND OBJECTPROPERTY(id, N'IsUserTable') = 1
> end
> 
> <><>><><><<><>><><><<><>><><><<><>><><><<><>><><><

This gives me error 156:  Incorrect syntax near the keyword 'Begin'.


More information about the thelist mailing list