954,566 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Msg 156 while using if exists, execute

if not exists
(select * from sysobjects where name='amrreconAccountsTB')
begin
execute "create amrreconAccountsTB(acct_id char(2048) NULL)"
end;
Message from server 'NOCTREPI04' (Msg 156, Severity 15, State 2):
error near the keyword 'end'.
Can someone please help me and tell me what is the syntax error here?

vs.vaidyanathan
Newbie Poster
23 posts since May 2009
Reputation Points: 28
Solved Threads: 0
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You
View similar articles that have also been tagged: