功能上的问题无法纠正 [英] problem in function not able to rectify

问题描述

  CREATE   FUNCTION  getCountID（ @EmpID   INT ）
  RETURNS   int  
  AS   BEGIN  
  DECLARE   @ COUNT   INT  
  SELECT  COUNT（*） INTO   @ COUNT   FROM  Emp_table 
 返回  @ COUNT  
  END  

i创建此函数时出错。我在做错了。请帮助

解决方案

你弄错了。

纠正它

  SELECT  @ COUNT = COUNT（*） FROM  emp_table 

  SELECT  COUNT（*） INTO   @ COUNT   FROM  join1 

SELECT ... INTO ... FROM ...是用数据填充表格。要将单个变量设置为select的结果，请使用此表单：

  SELECT   @ COUNT  = COUNT（*） FROM  join1 

了解详情这里： http://technet.microsoft.com/en-us/library/ms187330.aspx [ ^ ]

你的选择状态在这里不行它应该是

  SELECT   @ COUNT  = COUNT（*） FROM  Emp_table 

< br $>


全功能：

  CREATE   FUNCTION  getCountID 
（
  @EmpID   INT  
）
  RETURNS   int  
  AS  
  BEGIN  
  DECLARE   @ COUNT   INT  
  SELECT   @ COUNT  = COUNT（*） FROM  Emp_table 
  RETURN   @ COUNT  
  END  

CREATE FUNCTION getCountID( @EmpID INT) 
RETURNS int
AS BEGIN
DECLARE @COUNT INT
SELECT COUNT(*) INTO @COUNT FROM Emp_table
RETURN @COUNT
END

i am getting error while creating this functio. where i am doing wrong.please help

解决方案

You are making mistake.
correct it

SELECT @COUNT=COUNT(*) FROM emp_table

SELECT COUNT(*) INTO @COUNT FROM join1

SELECT ... INTO ... FROM... is to fill tables with data. To set a single variable to the result of a select use this form:

SELECT @COUNT = COUNT(*) FROM join1

Read more here: http://technet.microsoft.com/en-us/library/ms187330.aspx[^]

Your select state was not ok here it should be

SELECT @COUNT = COUNT(*) FROM Emp_table

Full Function:

CREATE FUNCTION getCountID
( 
	@EmpID INT
) 
RETURNS int
AS 
BEGIN
	DECLARE @COUNT INT
	SELECT @COUNT = COUNT(*) FROM Emp_table
	RETURN @COUNT
END

这篇关于功能上的问题无法纠正的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！