PB中如何创建存储过程

2024-11-27 16:12:25
推荐回答(1个)
回答1:

string ls_sql

ls_sql = 'create procedure popo4 (@id int) as begin set nocount on end if (@id is null) begin select property, version, value, lvalue from dbo.dtproperties where @id=objectid end else begin select count(*) from aa end'

execute immediate :ls_sql;