当我执行的时候 报出这样的错误:
服务器: 消息 170,级别 15,状态 1,行 1
第 1 行: ' ' 附近有语法错误。为什么啊?CREATE PROCEDURE peoplechange
AS
begin
declare @sqlStr varchar(5000)
declare @oldBaseName varchar(50)
declare @newBaseName varchar(50)
declare @DataTableName varchar(50)
set @oldBaseName='icme'
set @newBaseName='icme2'
set @DataTableName='上课表' begin
------插入上课表
while @DataTableName='上课表'
begin
select @sqlStr='insert into '+@newBaseName+'..上课表'
select @sqlStr=@sqlStr+'(id,课题编号,人员编号,日期,状态) '
select @sqlStr=@sqlStr+'select left(newid(),35),isnull('+@oldBaseName+'..上课表.课题编号,'' ''),isnull('+@oldBaseName+'..上课表.人员编号'' ''),isnull('+@oldBaseName+'..上课表.日期,'' ''),0 '
select @sqlStr=@sqlStr+'from '+@oldBaseName+'..上课表 'exec(@sqlStr)
break
endend
end
服务器: 消息 170,级别 15,状态 1,行 1
第 1 行: ' ' 附近有语法错误。为什么啊?CREATE PROCEDURE peoplechange
AS
begin
declare @sqlStr varchar(5000)
declare @oldBaseName varchar(50)
declare @newBaseName varchar(50)
declare @DataTableName varchar(50)
set @oldBaseName='icme'
set @newBaseName='icme2'
set @DataTableName='上课表' begin
------插入上课表
while @DataTableName='上课表'
begin
select @sqlStr='insert into '+@newBaseName+'..上课表'
select @sqlStr=@sqlStr+'(id,课题编号,人员编号,日期,状态) '
select @sqlStr=@sqlStr+'select left(newid(),35),isnull('+@oldBaseName+'..上课表.课题编号,'' ''),isnull('+@oldBaseName+'..上课表.人员编号'' ''),isnull('+@oldBaseName+'..上课表.日期,'' ''),0 '
select @sqlStr=@sqlStr+'from '+@oldBaseName+'..上课表 'exec(@sqlStr)
break
endend
end
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货