[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