create procedure proc_temp
@knowledge varchar(10)
as
declare @knowledgeColumn varchar(10)
set @knowledgeColumn=@knowledge select SUM(@knowledgeColumn) from Score1
提示操作数数据类型 varchar 对于 sum 运算符无效新人请高手指点!
@knowledge varchar(10)
as
declare @knowledgeColumn varchar(10)
set @knowledgeColumn=@knowledge select SUM(@knowledgeColumn) from Score1
提示操作数数据类型 varchar 对于 sum 运算符无效新人请高手指点!
@knowledge varchar(10)
as
declare @knowledgeColumn varchar(10)
set @knowledgeColumn=@knowledge EXEC('select SUM('+@knowledgeColumn+') from Score1')
@knowledge varchar(10)
as exec('select SUM('+@knowledge+') from Score1')
exce proc_temp @knowledge='列名'
exce proc_temp @knowledge='列名'
引用 9 楼 andy_liucj 的回复:
exce proc_temp '列名' 这样,,,汗提示'列名'附近有语法错误!
[
/Quote]大哥,可以查一下联机帮助--存储过程
列名是说你传的变量值........
EXEC proc_temp '参数值'
还有几种方法
INSERT TB SELECT 1
GO
create procedure proc_temp
@knowledge varchar(10)
as
declare @knowledgeColumn varchar(10)
set @knowledgeColumn=@knowledge EXEC('select SUM('+@knowledgeColumn+') from TB')
EXEC proc_temp 'ID'
-----------
1(所影响的行数为 1 行)
INSERT TB SELECT 1
GO
create procedure proc_temp
@knowledge varchar(10)
as
declare @knowledgeColumn varchar(10)
set @knowledgeColumn=@knowledge EXEC('select SUM('+@knowledgeColumn+') from TB')
EXEC proc_temp 'ID'
-----------
1(所影响的行数为 1 行)
EXEC('select '+@result+'=SUM('+@knowledgeColumn+') from Score1') ???