sql表名作为参数传递

Question

    CREATE PROCEDURE UPKJ90Detail @StatusID INT, @IOTime VARCHAR ( 50 ), @UniqueId bigint AS UPDATE DetailRealData{0} 
    SET StatusID = @StatusID     
WHERE
    UniqueId = @UniqueId 
    AND IOTime BETWEEN CONVERT ( VARCHAR,@IOTime, 120 ) + '.000' 
    AND CONVERT ( VARCHAR,@IOTime, 120 ) + '.999'

读取txt文件中的sql语句
将表名作为参数传递怎么写呢？

Answer 1

有个 exec 方法执行动态SQL语句，你可以试一试
https://blog.csdn.net/qq_43574777/article/details/103580779