Conversion Error in Dynamic Query

See more:

SQL

server

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.