Forum Replies Created

Viewing 2 posts - 1 through 3 (of 3 total)

  • RE: A Check and Foreign Key Constraint Improves Query Performance

    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...

  • RE: if Exists

    Try this way..

    DECLARE @CNT2 VARCHAR(100)

    SET @SQLQuery = N'SELECT @CNT = COUNT(*) FROM [' + @TableName + '] WITH (NOLOCK) WHERE [' + @ColumnName + ']= ' + CHAR(39) + @Value...

Viewing 2 posts - 1 through 3 (of 3 total)