Viewing 2 posts - 1 through 2 (of 2 total)
Based on my experience of a database where million of records are present and being operated for inserted/updated/deleted in a year. We were having proper constraints for data integrity purpose...
April 25, 2013 at 10:53 pm
#1610196
Try this way..
DECLARE @CNT2 VARCHAR(100)
SET @sqlquery = N'SELECT @CNT = COUNT(*) FROM [' + @TableName + '] WITH (NOLOCK) WHERE [' + @ColumnName + ']= ' + CHAR(39)...
March 3, 2012 at 2:53 am
#1454425