动态查询中的转换错误 [英] Conversion Error in Dynamic Query

问题描述

声明@in int



声明@ t1 varchar（300）



set @ t1 = 'tbl_401_Employee_Creation'



set @in ='（''从'+ @ t1 +'中选择计数（emp_id））'



选择@in作为扭转







我必须将值发送到主表和子表一次。主表中的主键是identity。当我编写代码来获取主数据时，它会显示错误，而不是获取值，而是保持为查询。

declare @in int

Declare @t1 varchar(300)

set @t1 = 'Tbl_401_Employee_Creation'

set @in ='(''Select count(emp_id) from' + @t1+ ')'

select @in as twist



I have to send the values to master and child tables at a time . here primary key in master table is identity.when i write code to get that primary it shows error that is is not getting value instead it remains as query.

推荐答案

Go通过 sp_executesql [ ^ ]执行动态查询。

Go through sp_executesql[^] to execute dynamic queries.

这篇关于动态查询中的转换错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！