declare @sql nvarchar(2000)
declare @cou int
declare @id varchar(20)
set @id='1'
set @sql='select @count=count(*) from calllog0001 where id=@id'
exec sp_executesql @sql, N'@count int out,@id varchar(20)', @cou out ,@id
print @cou
declare @cou int
declare @id varchar(20)
set @id='1'
set @sql='select @count=count(*) from calllog0001 where id=@id'
exec sp_executesql @sql, N'@count int out,@id varchar(20)', @cou out ,@id
print @cou