Something like sp_executesql in MSSQL

Dev Shed Forums Sponsor:

November 15th, 2006, 12:46 AM

Registered User

Join Date: Nov 2006

Posts: 4

Time spent in forums: 1 h 24 m 20 sec
Reputation Power: 0

Something like sp_executesql in MSSQL

does firebird have something like sp_executesql in MSSQL ?
Thanks

November 15th, 2006, 08:57 AM

Contributing User

Join Date: Jun 2003

Posts: 62

Time spent in forums: 13 h 3 m 18 sec
Reputation Power: 7

Quote:

Originally Posted by duclt2002

does firebird have something like sp_executesql in MSSQL ?
Thanks

See EXECUTE STATEMENT

Comments on this post

pabloj agrees!

November 16th, 2006, 04:05 AM

Registered User

Join Date: Nov 2006

Posts: 4

Time spent in forums: 1 h 24 m 20 sec
Reputation Power: 0

execute statement ??? help

CREATE OR ALTER PROCEDURE DEL_DMKHO (MMA_KHO Varchar(16))
AS

begin
execute statement 'delete from dmkho where ma_kho = ' || mma_kho;
end

Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Something like sp_executesql in MSSQL

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Forum Jump