为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:WINDOS
【CPU】:
【问题描述】*:(sbdate between ${start_time} and ${end_time} or finishtime between ${finishtime1} and ${finishtime2})
回答 0
暂无回答
竹汐
这样可以嘛
CREATE OR REPLACE PROCEDURE T_1208(TAB VARCHAR(100),COL VARCHAR(100),ID INT)
AS
BEGIN
EXECUTE IMMEDIATE 'SELECT '||COL||' FROM '||TAB||' WHERE ID>? ' USING ID;
END;
CREATE OR REPLACE PROCEDURE T_1208(ID INT)
AS
BEGIN
EXECUTE IMMEDIATE 'SELECT * FROM D_I WHERE ID>? AND DATE_TIME>? ' USING ID,'2021-1-1';
END;
这样可以嘛