[SQL]從sp取得值

declare @AAA VARCHAR(10)

  CREATE TABLE #TMP_DEPT

  (

  COMPID VARCHAR(5)

  ,SEG  VARCHAR(5)

  ,SEGNM  VARCHAR(5)

  ,[TEXT]  VARCHAR(50)

  ,DEPTID VARCHAR(10)

  ,DEPTSIMNM VARCHAR(20)

  )

  INSERT INTO #TMP_DEPT EXEC HDUSP_IFCOM_GETFNDEPT2_A00 'HD','1', 'LG000','','FID'

 

 SELECT @AAA =DEPTID  FROM #TMP_DEPT

  SELECT @AAA

  DROP TABLE #TMP_DEPT