IF exists(SELECT * FROM sysobjects WHERE NAME='usptable2' and TYPE='P')
DROP PROCEDURE usptable2
GOCREATE PROCEDURE usptable2
AS
declare @tempvar1 int
select @tempvar1=var1 from table1 where
.....
update table2 set ..... where t2var2< @tempvar1
DROP PROCEDURE usptable2
GOCREATE PROCEDURE usptable2
AS
declare @tempvar1 int
select @tempvar1=var1 from table1 where
.....
update table2 set ..... where t2var2< @tempvar1
AS
@tempvar1 int;
select top 1 @tempvar1 = var1 from table1
.....
update table2 set ..... where t2var2< @tempvar1
AS
@tempvar1 int;
select top 1 @tempvar1 = var1 from table1
.....
update table2 set ..... where t2var2< @tempvar1
DROP PROCEDURE usptable2
GOCREATE PROCEDURE usptable2
AS
@tempvar1 int
select @tempvar1=var1 from table1
.....
update table2 set ..... where t2var2< @tempvar1-------------
定时执行:企业管理器-》管理-》sql server代理(要启动服务)-》作业新建一个作业就可以了。