SQL中的表值参数 [英] Table-Valued Parameters in SQL

问题描述

Create TYPE PassType as table (Grade int,TotoP int)
Declare @Pass PassType
insert @Pass Select Grade, COUNT(ProgressionStatus)
             from LearnerProgression
             where AcademicYear='2010'; and EmisCode='500171421'
             group by Grade

得到了这段代码，但给了我一个错误---

got this piece of code but it gives me an error---

Msg 2715, Level 16, State 3, Line 6
Column, parameter, or variable #1: Cannot find data type PassType.
Parameter or variable '@Pass' has an invalid data type.
Msg 1087, Level 16, State 1, Line 3
Must declare the table variable "@Pass".

推荐答案

您无需创建类型，只需定义变量作为表:

You don''t need to create a type, just define the variable as a table:

Declare @Pass as table (Grade int,TotoP int)
insert @Pass Select Grade, COUNT(ProgressionStatus)
             from LearnerProgression
             where AcademicYear='2010' and EmisCode='500171421'
             group by Grade

另请注意，在AcademicYear=''2010''

Also note that you had an extra semeicolon after AcademicYear=''2010''

尝试以下操作后，您会产生额外的半封闭现象:

try the following :

Create TYPE PassType as table (Grade int,TotoP int)
GO
Declare @Pass PassType
insert @Pass Select Grade, COUNT(ProgressionStatus)
             from LearnerProgression
             where AcademicYear='2010' and EmisCode='500171421'
             group by Grade

这篇关于SQL中的表值参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！