Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
ALTER PROCEDURE [dbo].[TEL_SelectCountInVoiceChecked] @ColumnName1 nvarchar(255)= NULL, @TableName varchar(100) = NULL, @Value varchar(100) = NULL AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; DECLARE @SQL NVARCHAR(MAX) SET @SQL = 'SELECT COUNT (*)' SET @SQL = @SQL + ' FROM [dbo].[' + @tableName + ']' IF @ColumnName1 <> '' SET @SQL = @SQL + ' WHERE ' + CAST(@ColumnName1 AS NVARCHAR(30))+ '' +'=' + CAST(@Value AS NVARCHAR(30)) SET @SQL = @SQL EXECUTE (@SQL) END
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.