Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.73K
1 Posted Topic
[CODE]declare @query nvarchar(Max) ,@tbl nvarchar(Max) ,@col nvarchar(Max) ,@val nvarchar(Max) -- give tbl=tablename,col=column,val=value set @query='select @retVal= count(*) from '+@tbl+' where '+@col+' like ''%'+@val+'%''' EXECUTE sp_executesql @query, N'@retVal int OUTPUT', @retVal OUTPUT select @retVal[/CODE]
The End.