declare @sNumber varchar(20)
declare @sYear int
declare @sPeriod int
set @sNumber='qms'
set @sYear=2007
set @sPeriod=12
DECLARE @sql0 varchar(8000)
set @sql0='select IC.FPhysicID,FBegQty into ##ICBal from T_Physic Ph left outer join T_ICBal IC on IC.FPhysicID=Ph.FID
where ( ph.FNumber like '''%+@sNumber +%'''or ph.FPYName like '''%+@sNumber+%''' or ph.FName like '''%+@sNumber+%''') and
FYear='+convert(char(4),@sYear)+' and FPeriod='+convert(char(4),@sPeriod)+''
print @sql0exec @sql0
declare @sYear int
declare @sPeriod int
set @sNumber='qms'
set @sYear=2007
set @sPeriod=12
DECLARE @sql0 varchar(8000)
set @sql0='select IC.FPhysicID,FBegQty into ##ICBal from T_Physic Ph left outer join T_ICBal IC on IC.FPhysicID=Ph.FID
where ( ph.FNumber like '''%+@sNumber +%'''or ph.FPYName like '''%+@sNumber+%''' or ph.FName like '''%+@sNumber+%''') and
FYear='+convert(char(4),@sYear)+' and FPeriod='+convert(char(4),@sPeriod)+''
print @sql0exec @sql0
解决方案 »
- SQL server 2005 安装 我是xp系统
- SQL动态行变列
- 数据库报错:Could not find the index entry for RID '1601aef3060000000000010000' in index page (1:12963),
- sql的锁的信息保存在哪张表里面?
- SQL server 2005 的奇怪问题,盼望各位高手帮助解决!
- SQLserver 中 一个表中 有几十万的记录, 通过ADO像这个表中录入一条数据, 和取出一条记录的速度大概有多少?
- 我怎么锁住数据库表的某字段不让修改?
- 同步后, 对表操作时出现: The updatelineage function requires 2 arguments. ( 顶也有分!)
- 请大家帮帮忙,用Delete 语句误删除了一些数据怎样恢复。
- sql server表的问题!急
- 相关子查询和内连接的优先级问题
- 表遍历问题,昨天问过解决不了,再请教大家。
declare @sYear int
declare @sPeriod int
set @sNumber='qms'
set @sYear=2007
set @sPeriod=12
DECLARE @sql0 varchar(8000)
set @sql0='select IC.FPhysicID,FBegQty into ##ICBal from T_Physic Ph left outer join T_ICBal IC on IC.FPhysicID=Ph.FID
where ( ph.FNumber like ''%'+@sNumber +'%''or ph.FPYName like ''%'+@sNumber+'%'' or ph.FName like ''%'+@sNumber+'%'') and
FYear='+convert(char(4),@sYear)+' and FPeriod='+convert(char(4),@sPeriod)+''
print @sql0 exec @sql0