sql - How to use Table Variable in Dynamic Query -

i want use table variable instead of temp table main query construction dynamic . dynamic query in single quote how can fetch data @tablevariable. dont want remove dynamic query because of parameter added later.

e.g. following error code , have wrote table variable dynamic query........

/*declare table variable*/ declare @tempvehicles table     (         [vehicleid] int     )    /*insert data table variable*/ insert @tempvehicles (     [vehicleid] ) select  vehicleid tbl_vehicles  /*dynamic query , main sql construction*/ declare @sql nvarchar(max) set @sql ='select cust_id,a.vehicleid,gisinfo             @tempvehicles inner join tbl_gisdata b on a.vehicleid=b.vehicleid'  execute sp_executesql @sql 

help me , in .

thanks in advance.

try :

create type integertabletype table (id int); go  declare @tempvehicles integertabletype;   insert  @tempvehicles values (1);      declare @sql nvarchar(max); set @sql ='select *             @tempvehicles;';   execute sp_executesql @sql,n'@tempvehicles integertabletype readonly', @tempvehicles;