I am setting up a recordset using the following code and SQL statement:<BR><BR>Dim rsCurrentLadders As New ADODB.Recordset<BR>Dim strCLad As String<BR> <BR>strCLad = "SELECT Ladders.LadderName " & ...
Greetings,<BR><BR>I've used "WHERE 1=1" for a long time in dynamic where clauses in which every condition is optional, and lately I heard it suggested that this can cause full table scans by itself.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback