@mapping详细定义表变量.

在SQL Server 2005中执行我的过程时，我遇到错误必须声明标量变量@mappingdetails".

@mappingdetails defined table variable .

I''m facing an error ''Must declare the scalar variable @mappingdetails" '' while executing my procedure in SQL server 2005.

而不是像这样创建临时表

声明@mappingdetails TABLE(
mapping_id varchar(40)，
folder_name varchar(40)，
mapping_name varchar(40)，
session_id varchar(40))

尝试

创建表#mappingdetails(mapping_id varchar(40)，
folder_name varchar(40)，
mapping_name varchar(40)，
session_id varchar(40))

instead of creating temp table like this

DECLARE @mappingdetails TABLE (
mapping_id varchar(40),
folder_name varchar(40),
mapping_name varchar(40),
session_id varchar(40))

try

create table #mappingdetails ( mapping_id varchar(40),
folder_name varchar(40),
mapping_name varchar(40),
session_id varchar(40))

更改以下代码

Hi,

Change below code

Select @mappingdetails.mapping_id from @mappingdetails

像这样

Like this

Select Tmp.mapping_id from @mappingdetails as Tmp