EXEC ('SELECT 日期,最低气温,最高气温 FROM '+@RegionName+' WHERE 日期 BETWEEN @BeginningDate AND @EndingDate ')
解决方案 »
- SQL选查询再过滤重复值问题。
- sql 2005 输入设置了默认值。但是添加字段时候仍然为NULL
- 请教一段sql语句,字符串匹配的问题
- job一启动,这个JOB的进程都是sleeping
- 一个捆扰我的很久的一个问题,望各位赐教!!怎样用SELECT去查?三个表…………
- 请教反编译问题
- 请问如何在SQL Server的查询中,返回记录的当前序号?
- 求一个比较特别的数据查询
- 求助急
- sqlserver 中 左补零 的函数是??????
- 请问怎样用SQL语句实现从远程计算机上下载数据库到本地(sql到access),而且只下载被更新表的内容?最好有原码,多谢!!
- 数据库还原的问题!应该属于初级问题!
SELECT 日期,最低气温,最高气温 FROM 广州 WHERE 日期 BETWEEN '2001/01/01' AND '2001/12/31'
就没有问题!
@RegionName nvarchar(10),
@BeginningDate DateTime,
@EndingDate DateTime
AS
EXEC ('SELECT 日期,最低气温,最高气温 FROM '+@RegionName+' WHERE 日期 BETWEEN '+ '''' + @BeginningDate+ ''''+' AND '+''''+@EndingDate+'''')
GO
告诉我连加几个 '''' 是什么用意啊?
谢谢!!!
create table ai (i datetime,di varchar(100))
insert into ai select '20030918','hn'
insert into ai select '20030918','hn'
insert into ai select '20030901','hn'
insert into ai select '20031001','gd'
insert into ai select '20031001','gd'
gocreate proc proc_1
@stime datetime,@etime datetime,@di varchar(100)
as
declare @sql nvarchar(4000)
select @sql='select * from ai where i BETWEEN @stime and @etime and di=@di'
print @sql
exec sp_executesql @sql,
N'@stime datetime,@etime datetime,@di varchar(100)',
@stime=@stime,@etime=@etime,@di=@digoexec proc_1 '2003/09/01','2003/10/01','hn'
insert into aii select '20030918','hn'
insert into aii select '20030918','hn'
insert into aii select '20030901','hn'
insert into aii select '20031001','gd'
insert into aii select '20031001','gd'
gocreate table ai (i datetime,di varchar(100))
insert into ai select '20030918','hn'
insert into ai select '20030918','hn'
insert into ai select '20030901','hn'
insert into ai select '20031001','gd'
insert into ai select '20031001','gd'
gocreate proc proc_1
@stime datetime,@etime datetime,@di varchar(100),@tablename nvarchar(100)
as
declare @sql nvarchar(4000)
select @sql='select * from '+@tablename+' where i BETWEEN @stime and @etime and di=@di'
print @sql
exec sp_executesql @sql,
N'@stime datetime,@etime datetime,@di varchar(100)',
@stime=@stime,@etime=@etime,@di=@digoexec proc_1 '2003/09/01','2003/10/01','hn','ai'
go
exec proc_1 '2003/09/01','2003/10/01','hn','aii'
go