【SQLServer】-如何实现定义变量，完成数据库的查询操作

--defined a variable
declare @changzhanid varchar(10) 
declare @ertuid varchar(10)  
declare @taskid varchar(10) 
declare @meteraddress varchar(30)
declare @tasktable varchar(12)
declare @sql varchar(500)
declare @starttime varchar(500)
declare @endtime varchar(500)
declare @dataitem varchar(500)

set @meteraddress='12010020'				------------Meter address
set @starttime='2013-01-01 14:00:00'				------------Query Startime
set @endtime='2013-04-29 14:30:00'				------------Query Endtime
set @dataitem='acq_date,ACQ_10,ACQ_12,ACQ_13'		------------Query Dataitem

begin
set @changzhanid=(select ertutask_record.changzhanid from ertutask_record inner join meter_record 
on  ertutask_record.changzhanid=meter_record.changzhanid and ertutask_record.ert