本文介绍了如何使这项工作?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
- Amit
--Amit
目前我已经开始创建一个过程,该过程获取参数,并且应该在一定条件下将一个表的内容复制到另一个表。我在这里复制了代码。它编译好。但没有任何影响。
Currently I have started creating a procedure, which gets the parameters and should copy the contents of one table to another with certain conditions. I have copied the codes here. It compiles good. But nothing is affected.
ALTER PROCEDURE sp_ArchiveTable1( @StartDate datetime, @EndDate datetime, @DateColumn VARCHAR(100), @TableName VARCHAR(100), @NewTableName VARCHAR(100) ) AS DECLARE @NextIDs TABLE(UniqueID int primary key) SELECT * INTO [@NewTableName] FROM [@TableName] WHERE [@DateColumn] >= @StartDate AND [@DateColumn] <= @EndDate推荐答案
请参阅此文章:在存储过程中构建动态SQL [ ^ ] Please, see this article: Building Dynamic SQL In a Stored Procedure[^]
试试这个: Try this: ALTER PROCEDURE sp_ArchiveTable1( @StartDate datetime, @EndDate datetime, @DateColumn VARCHAR(100), @TableName VARCHAR(100), @NewTableName VARCHAR(100) ) AS BEGIN DECLARE @NextIDs TABLE(UniqueID int primary key) DECLARE @statement nchar(1000) = N'SELECT * INTO '+@NewTableName+' FROM '+@TableName+' WHERE '+@DateColumn+' BETWEEN '''+CONVERT(VARCHAR(100), @StartDate)+''' AND '''+CONVERT(VARCHAR(100), @EndDate)+'''' PRINT @statement EXEC sys.sp_ExecuteSQL @statement END go
但是你必须要小心 SQL注入 [ ^ ]。 请参阅 SQL注入:它是什么? [ ^ ]
But you''ll have to be careful about SQL injection[^]. See SQL Injection: What is it?[^]
我认为你必须使用exec(这里是你的查询)命令来执行此操作。 希望这有帮助...... I think you have to use exec(here your query) command for this to get executed. Hope this helps...
更多推荐
如何使这项工作?
发布评论