当我执行产生错误 [英] When I Am Execute The Produce The Error

问题描述

  alter   PROC  [DBO]。[Proc_GetActiveDistrictWise] '  chennai' 
（
  @District   varchar （ 30 ）
）
  AS  
  BEGIN  
  DECLARE   @ VAR   VARCHAR （ 500 ）
  SET  @ VAR = '  SELECT COLLEGENAME' + ' ，' + ' 来自COLLEGEDETAILS的位置，其中DISTRICT =' + @ DISTRICT 
  EXEC （ @ VAR ）
  END  

我在chennai.Error中传递参数

执行存储过程时出错

错误是

Msg 207，Level 16，State 1，Line 1

无效的列名'chennai'

解决方案

  alter   PROC  [DBO]。[Proc_GetActiveDistrictWise] 
 
  @ District   varchar （ 30 ）
 
  AS  
  BEGIN  
  DECLARE   @ VAR   VARCHAR （ 500 ）
  SET  @ VAR = '  SELECT COLLEGENAME' + ' ，' + ' 位置来自于学区，地区=' + @ District 
  EXEC （ @ VAR ）
  END  

'chennai'已从程序中删除。



alter proc dbo.Proc_GetActiveDistrictWise 是第一个程序语句，包含它的名称，所以你就不能在那里传递参数。

您可以做的是，在解决方案资源管理器中右键单击过程>>执行>>它将提供具有您在过程中定义的参数数量的对话框。在那里你可以传递你想要的任何价值。



试一试。



祝你好运。

试试这个

  alter   PROC  [DBO]。[Proc_GetActiveDistrictWise] '  chennai' 
（
  @ District   varchar （ 30 ）
）
  AS  
  BEGIN  
  DECLARE   @ VAR   VARCHAR （< span class =code-digit> 500 ）
  SET  @ VAR = '  SELECT COLLEGENAME' + ' ，' + '  LOCED FROM COLLEGEDETAILS DISTRICT = ' + ' ''' + @ DISTRICT + ' '''  
  EXEC （ @ VAR ）
  END  

alter PROC [DBO].[Proc_GetActiveDistrictWise]  'chennai'
(
  @District varchar(30)
)
AS
BEGIN
DECLARE @VAR VARCHAR(500)
SET @VAR= 'SELECT COLLEGENAME'+','+'LOCATION FROM COLLEGEDETAILS WHERE DISTRICT= '+@DISTRICT
EXEC(@VAR)
END

I was pass the parameter in chennai.Error raised
Error on executing a stored procedure
error are
Msg 207, Level 16, State 1, Line 1
Invalid column name 'chennai'

解决方案

alter PROC [DBO].[Proc_GetActiveDistrictWise]

  @District varchar(30)

AS
BEGIN
DECLARE @VAR VARCHAR(500)
SET @VAR= 'SELECT COLLEGENAME'+','+'LOCATION FROM COLLEGEDETAILS WHERE DISTRICT= '+@District 
EXEC(@VAR)
END

'chennai' is removed from the procedure.

alter proc dbo.Proc_GetActiveDistrictWise is the very first statement of procedure and that contains the name of it, So you just cannot pass parameter over there.
What you can do is, in Solution Explorer right click on Procedure >> Execute >> It will come up with the dialog having number of parameters that you've defined within procedure. Over there you can pass whatever value you want.

Give it a try.!

Good Luck.

Try this

alter PROC [DBO].[Proc_GetActiveDistrictWise]  'chennai'
(
  @District varchar(30)
)
AS
BEGIN
DECLARE @VAR VARCHAR(500)
SET @VAR= 'SELECT COLLEGENAME'+','+'LOCATION FROM COLLEGEDETAILS WHERE DISTRICT= '+ '''' +@DISTRICT + ''''
EXEC(@VAR)
END

这篇关于当我执行产生错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！