存储过程动态sql语句

mysq

DROP PROCEDURE IF EXISTS x.`wk`;
DELIMITER $$
CREATE PROCEDURE `x`.`wk`()
BEGIN
    DECLARE crs VARCHAR ( 500 );
    DECLARE t VARCHAR ( 50 );

    SET t = CONCAT( "t_track_recording_", YEAR ( CURRENT_DATE ) );
    SET crs = CONCAT( "CREATE TABLE IF NOT EXISTS ", t, " like t_track_recording; " );
    
    SET @sql = crs;
    PREPARE stmt FROM @sql;         -- 预处理动态sql语句
    EXECUTE stmt ;                        -- 执行sql语句
    DEALLOCATE PREPARE stmt;      -- 释放prepare    
    
END$$

sybase

DECLARE @TableName VARCHAR(50),@Sql NVARCHAR (MAX),@OrderID INT;
  SET @TableName = 'Orders';
  SET @OrderID = 10251;
  SET @sql =  　　　　'SELECT * FROM '+QUOTENAME(@TableName) +'WHERE OrderID = '+ 　　　　CAST(@OrderID AS VARCHAR(10))+' ORDER BY ORDERID DESC'
  EXEC(@sql);

参考