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语句
将表名作为参数传递怎么写呢?
有个 exec 方法执行动态SQL语句,你可以试一试
https://blog.csdn.net/qq_43574777/article/details/103580779