SQLServer拼接语句使用between and 出错，求助
- WBOYOriginal
- 2016-06-07 15:25:091543browse
最后答案： ALTER procedure [dbo].[GetBy_ItemName_BetweenTime] @itemName nvarchar(50), @beginTime datetime, @endTime datetime as declare @tableName nvarchar(50) set @tableName = (select TableName from TQueryItem where ItemName=@itemName) ex
最后答案：
ALTER procedure [dbo].[GetBy_ItemName_BetweenTime]
@itemName nvarchar(50),
@beginTime datetime,
@endTime datetime
as
declare @tableName nvarchar(50)
set @tableName = (select TableName from TQueryItem where ItemName=@itemName)
exec ('select * from '+@tableName+' where YYMMDD between '''+@beginTime+''' and '''+@endTime+'''')
时间上的单引号问题。。。我蠢了
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：SqlServer读取数据时发生的诡异问题Next article：Oracle数据库操作大全（七）