Thursday, 12 September 2013

Execute create procedure after drop procedure by otl_cursor::direct_exec of OTL

Execute create procedure after drop procedure by otl_cursor::direct_exec
of OTL

I used 'SQL SERVER 2008 R2'(Driver={SQL Server}) and 'otlv4' in my
program. There is an error when executing 'create procedure' after 'drop
procedure'. The code is like this:
otl_cursor::direct_exec( m_DBConnection,
"if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[MyProcName]') and OBJECTPROPERTY(id,
N'IsProcedure') = 1) drop procedure [dbo].[MyProcName]");
otl_cursor::direct_exec( m_DBConnection,
"CREATE PROCEDURE GetUserForAvatar"
"@sAvatar nvarchar(50)"
"AS "
"BEGIN "
" select ixAtlasUser from Avatar where (sAvatar = @sAvatar)"
"END "
);

No comments:

Post a Comment