use following query

declare @Query nvarchar(500),@parameters nvarchar(500)

set @Query='select @NULL = count(*) from #t1 where '+@Nm+' is null'

set @parameters='@Null int output'

exec sp_executesql @Query,@parameters,@Null=@Null output

print @NULL

insted of

select...

Thanks Mahesh.

Dear ,All

City_Master table having Primary key City_ID,

still how to get Serial No.

Mahesh, i want to use variable @a in next statement after EXECUTE.

How can i use it?

insert into sample_tmp

select 'Ripal',45,getdate() union all

select 'Patel',145,getdate() union all

select 'Rakesh',79,getdate() union all

select 'Mukesh',12,getdate() union all

select 'Bantu',55,getdate()

in above statement 'Ripal' is first row data for column name,45 is for age and...

Thanks Mahesh Bote ,

My problem gets Solve, now i need same primary key for INSERT statement. means i want Primerry key value of last inserted statement,

If only one row...